[Home] [Help]
838: ,c_effective_start_date date
839: ,c_effective_end_date date) is
840: select distinct(ptp.end_date) end_date
841: from per_time_periods ptp
842: ,pay_payroll_actions ppa
843: ,pay_assignment_actions paa
844: where ptp.time_period_id = ppa.time_period_id
845: and ppa.payroll_action_id = paa.payroll_action_id
846: and ppa.effective_date between c_effective_start_date
857: ,c_effective_start_date date
858: ,c_effective_end_date date) is
859: select distinct(ptp.end_date) end_date
860: from per_time_periods ptp
861: ,pay_payroll_actions ppa
862: ,pay_assignment_actions paa
863: where ptp.time_period_id = ppa.time_period_id
864: and ppa.payroll_action_id = paa.payroll_action_id
865: -- and ppa.effective_date between c_effective_start_date
1242: IS
1243: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1244: --paa.assignment_action_id
1245: FROM pay_assignment_actions paa
1246: ,pay_payroll_actions ppa
1247: WHERE paa.assignment_id = p_assignment_id
1248: AND ppa.action_status = 'C'
1249: AND paa.action_status = 'C'
1250: AND paa.payroll_action_id = ppa.payroll_action_id
1296: ,nvl(RR.end_date,p_end_date) end_date
1297: ,FEED.scale scale
1298: ,RR.run_result_id
1299: FROM pay_assignment_actions BAL_ASSACT
1300: ,pay_payroll_actions BACT
1301: ,pay_assignment_actions ASSACT
1302: ,pay_payroll_actions PACT
1303: ,pay_run_results RR
1304: ,pay_run_result_values TARGET
1298: ,RR.run_result_id
1299: FROM pay_assignment_actions BAL_ASSACT
1300: ,pay_payroll_actions BACT
1301: ,pay_assignment_actions ASSACT
1302: ,pay_payroll_actions PACT
1303: ,pay_run_results RR
1304: ,pay_run_result_values TARGET
1305: ,pay_balance_feeds_f FEED
1306: ,per_time_periods PTP
1434:
1435: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1436: ,ppa.date_earned
1437: FROM pay_assignment_actions paa
1438: ,pay_payroll_actions ppa
1439: WHERE paa.assignment_id = p_assignment_id
1440: AND ppa.action_status = 'C'
1441: AND paa.action_status = 'C'
1442: AND paa.payroll_action_id = ppa.payroll_action_id
1456: IS
1457: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1458: ,ppa.date_earned
1459: FROM pay_assignment_actions paa
1460: ,pay_payroll_actions ppa
1461: WHERE paa.assignment_id = p_assignment_id
1462: AND ppa.action_status = 'C'
1463: AND paa.action_status = 'C'
1464: AND paa.payroll_action_id = ppa.payroll_action_id
1487: ,peef.source_end_date
1488: ,ppa.date_earned
1489: FROM pay_entry_process_details perd
1490: ,pay_assignment_actions paa
1491: ,pay_payroll_actions ppa
1492: ,pay_element_entries_f peef
1493: WHERE peef.assignment_id = p_assignment_id
1494: AND perd.element_entry_id = peef.element_entry_id
1495: AND perd.source_asg_action_id = paa.assignment_action_id
2020: ) IS
2021: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2022: /* Assignment with Date worked for Run */
2023: FROM pay_assignment_actions BAL_ASSACT
2024: ,pay_payroll_actions BACT
2025: ,pay_assignment_actions ASSACT
2026: ,pay_payroll_actions PACT
2027: ,pay_run_results RR
2028: ,pay_element_types_f pet
2022: /* Assignment with Date worked for Run */
2023: FROM pay_assignment_actions BAL_ASSACT
2024: ,pay_payroll_actions BACT
2025: ,pay_assignment_actions ASSACT
2026: ,pay_payroll_actions PACT
2027: ,pay_run_results RR
2028: ,pay_element_types_f pet
2029: ,pay_input_values_f process_iv
2030: ,pay_run_result_values process
2064: ) IS
2065: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2066: /* Assignment with Date worked for Run */
2067: FROM pay_assignment_actions ASSACT
2068: ,pay_payroll_actions PACT
2069: ,pay_run_results RR
2070: ,pay_input_values_f process_iv
2071: ,pay_run_result_values process
2072: ,pay_run_result_values TARGET