[Home] [Help]
834: ,c_effective_start_date date
835: ,c_effective_end_date date) is
836: select distinct(ptp.end_date) end_date
837: from per_time_periods ptp
838: ,pay_payroll_actions ppa
839: ,pay_assignment_actions paa
840: where ptp.time_period_id = ppa.time_period_id
841: and ppa.payroll_action_id = paa.payroll_action_id
842: and ppa.effective_date between c_effective_start_date
850: ,c_effective_start_date date
851: ,c_effective_end_date date) is
852: select distinct(ptp.end_date) end_date
853: from per_time_periods ptp
854: ,pay_payroll_actions ppa
855: ,pay_assignment_actions paa
856: where ptp.time_period_id = ppa.time_period_id
857: and ppa.payroll_action_id = paa.payroll_action_id
858: and ppa.effective_date between c_effective_start_date
1221: IS
1222: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1223: --paa.assignment_action_id
1224: FROM pay_assignment_actions paa
1225: ,pay_payroll_actions ppa
1226: WHERE paa.assignment_id = p_assignment_id
1227: AND ppa.action_status = 'C'
1228: AND paa.action_status = 'C'
1229: AND paa.payroll_action_id = ppa.payroll_action_id
1275: ,nvl(RR.end_date,p_end_date) end_date
1276: ,FEED.scale scale
1277: ,RR.run_result_id
1278: FROM pay_assignment_actions BAL_ASSACT
1279: ,pay_payroll_actions BACT
1280: ,pay_assignment_actions ASSACT
1281: ,pay_payroll_actions PACT
1282: ,pay_run_results RR
1283: ,pay_run_result_values TARGET
1277: ,RR.run_result_id
1278: FROM pay_assignment_actions BAL_ASSACT
1279: ,pay_payroll_actions BACT
1280: ,pay_assignment_actions ASSACT
1281: ,pay_payroll_actions PACT
1282: ,pay_run_results RR
1283: ,pay_run_result_values TARGET
1284: ,pay_balance_feeds_f FEED
1285: ,per_time_periods PTP
1413:
1414: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1415: ,ppa.date_earned
1416: FROM pay_assignment_actions paa
1417: ,pay_payroll_actions ppa
1418: WHERE paa.assignment_id = p_assignment_id
1419: AND ppa.action_status = 'C'
1420: AND paa.action_status = 'C'
1421: AND paa.payroll_action_id = ppa.payroll_action_id
1435: IS
1436: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1437: ,ppa.date_earned
1438: FROM pay_assignment_actions paa
1439: ,pay_payroll_actions ppa
1440: WHERE paa.assignment_id = p_assignment_id
1441: AND ppa.action_status = 'C'
1442: AND paa.action_status = 'C'
1443: AND paa.payroll_action_id = ppa.payroll_action_id
1466: ,peef.source_end_date
1467: ,ppa.date_earned
1468: FROM pay_entry_process_details perd
1469: ,pay_assignment_actions paa
1470: ,pay_payroll_actions ppa
1471: ,pay_element_entries_f peef
1472: WHERE peef.assignment_id = p_assignment_id
1473: AND perd.element_entry_id = peef.element_entry_id
1474: AND perd.source_asg_action_id = paa.assignment_action_id
1992: ) IS
1993: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
1994: /* Assignment with Date worked for Run */
1995: FROM pay_assignment_actions BAL_ASSACT
1996: ,pay_payroll_actions BACT
1997: ,pay_assignment_actions ASSACT
1998: ,pay_payroll_actions PACT
1999: ,pay_run_results RR
2000: ,pay_input_values_f process_iv
1994: /* Assignment with Date worked for Run */
1995: FROM pay_assignment_actions BAL_ASSACT
1996: ,pay_payroll_actions BACT
1997: ,pay_assignment_actions ASSACT
1998: ,pay_payroll_actions PACT
1999: ,pay_run_results RR
2000: ,pay_input_values_f process_iv
2001: ,pay_run_result_values process
2002: ,pay_run_result_values TARGET
2030: ) IS
2031: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2032: /* Assignment with Date worked for Run */
2033: FROM pay_assignment_actions ASSACT
2034: ,pay_payroll_actions PACT
2035: ,pay_run_results RR
2036: ,pay_input_values_f process_iv
2037: ,pay_run_result_values process
2038: ,pay_run_result_values TARGET