[Home] [Help]
333: AND pbd.dimension_name = '_ASG_LE_PTD'
334: order by sort_index;
335:
336: /*Bug 4132149 - Modification begins here */
337: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
338: is
339: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
340: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
341: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
752: ,p_start_person in per_all_people_f.person_id%type
753: ,p_end_person in per_all_people_f.person_id%type
754: ,p_chunk in number
755: ) is
756: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
757: is
758: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
759: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
760: ,decode(pay_core_utils.get_parameter('PAYROLL',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL',legislative_parameters)) payroll_id
1340: c_start_date date,
1341: c_end_date date)
1342: IS
1343: SELECT paaf.payroll_id, pay.payroll_name
1344: FROM per_all_assignments_f paaf,
1345: pay_payrolls_f pay
1346: WHERE paaf.assignment_id = c_assignment_id
1347: and paaf.effective_end_date = (select max(effective_end_date)
1348: From per_assignments_f iipaf
2597: prrv.result_value amount,
2598: prr.run_result_id,
2599: pac.source_action_id
2600: FROM
2601: per_all_assignments_f paa
2602: ,pay_assignment_actions pac
2603: ,pay_payroll_actions ppa
2604: ,pay_run_results prr
2605: ,pay_element_types_f pet