ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729051A9E05362FB09050512 select pas.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, substr(ppl.FULL_NAME,1,20) EMPLOYEE_NAME, to_number(prv.RESULT_VALUE) RESULT_VALUE, prr.SOURCE_ID ELEMENT_ENTRY_ID from pay_payroll_actions pra, pay_assignment_actions paa, per_assignments_f pas, per_people_f ppl, pay_run_results prr, pay_element_types_f pet, pay_element_classifications pec, pay_run_result_values prv, pay_input_values_f piv where pra.BUSINESS_GROUP_ID = :P_BUSINESS_GROUP_ID and pra.TIME_PERIOD_ID = :P_TIME_PERIOD_ID and pra.PAYROLL_ID = :P_PAYROLL_ID and pra.CONSOLIDATION_SET_ID = NVL(:P_CONSOLIDATION_SET,pra.CONSOLIDATION_SET_ID) and pra.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID and paa.ASSIGNMENT_ID = pas.ASSIGNMENT_ID and pas.PERSON_ID = ppl.PERSON_ID and paa.ASSIGNMENT_ACTION_ID = prr.ASSIGNMENT_ACTION_ID and prr.STATUS = 'P' and prr.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID and pet.ELEMENT_NAME in (:c_element_name1,:c_element_name2) and pet.CLASSIFICATION_ID = pec.CLASSIFICATION_ID and pec.CLASSIFICATION_NAME = :c_classification_name and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID and prv.INPUT_VALUE_ID = piv.INPUT_VALUE_ID and piv.NAME = 'Amount' and prr.SOURCE_TYPE = 'E' and :P_SESSION_DATE between pas.effective_start_date and pas.effective_end_date and :P_SESSION_DATE between ppl.effective_start_date and ppl.effective_end_date and :P_SESSION_DATE between pet.effective_start_date and pet.effective_end_date &ORDER_BY_CLAUSE Y SSP SSPSHPAR US SSP ShPP Adoption Element Results Imported from BI Publisher Application: SSP Source: ShPP Adoption Element Results(XML) Short Name: SSPSHPAR DB package: SSP_SHARED_ADOPTION_RESULTS BI Publisher &order_by_clause :c_business_group_name :c_classification_name :c_consolidation_set_name :c_element_name1 :c_element_name2 :c_payroll_name :c_report_subtitle :c_sort_option :c_time_period_name :p_business_group_id :p_conc_request_id :p_consolidation_set :p_payroll_id :p_session_date :p_sort_option :p_spp_type :p_time_period_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Business Group ID 2 -10 :p_session_date Date select effective_date from fnd_sessions where session_id =userenv('SESSIONID') Y US Session Date Session Date 3 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y US Payroll Name Payroll Name 4 20 :p_consolidation_set LOV Oracle PY_SRS_CONSOLIDATION_SET Y select con.consolidation_set_id id, con.consolidation_set_name value, null description from pay_consolidation_sets con where con.business_group_id =fnd_global.per_business_group_id order by con.consolidation_set_name US Consolidation Set Consolidation Id 5 30 :p_time_period_id LOV Oracle PY_SRS_PAY_PERIOD_ID Y select time_period_id id, period_name value, null description from per_time_periods p,fnd_sessions f where p.payroll_id=:$flex$.py_srs_payroll and p.start_date<=f.effective_date and f.session_id= userenv('sessionid') order by p.start_date desc select p.period_name from per_time_periods p,fnd_sessions f where p.payroll_id = :$flex$.payroll_name and f.session_id = userenv('sessionid') and f.effective_date between p.start_date and p.end_date Y US Period Time Period 6 40 :p_sort_option LOV Oracle SSP_SSPRPELR_SORT_OPTION Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=103412 order by ffvv.flex_value select meaning from hr_lookups where lookup_code = 'A' and lookup_type = 'PAYRPEMV_EMP_DET' US Sort Option Sort Option 7 50 :debugflag Char N US Debug Flag Debug Flag :$flex$.payroll_name Payroll Name Period :$flex$.py_srs_payroll Payroll Name Period