[Home] [Help]
480: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
481: legislative_parameters) Legal_Employer_ID,
482: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
483: legislative_parameters) Assignment_SET_ID
484: FROM pay_payroll_actions
485: WHERE payroll_action_id = cp_payroll_action_id;
486:
487: ld_end_date DATE;
488: ln_business_group_id NUMBER;
836:
837: lv_sql_string :=
838: 'SELECT DISTINCT paf.person_id
839: FROM pay_assignment_actions paa,
840: pay_payroll_actions ppa,
841: per_assignments_f paf
842: WHERE ppa.business_group_id = ' || ln_business_group_id || '
843: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
844: fnd_date.date_to_canonical(ld_start_date) || ''')
858:
859: lv_sql_string :=
860: 'SELECT DISTINCT paf.person_id
861: FROM pay_assignment_actions paa,
862: pay_payroll_actions ppa,
863: per_assignments_f paf
864: WHERE ppa.business_group_id = ' || ln_business_group_id || '
865: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
866: fnd_date.date_to_canonical(ld_start_date) || ''')
930:
931: CURSOR c_get_emp_asg_range (cp_gre_id NUMBER,
932: cp_start_date DATE,
933: cp_end_date DATE) IS
934: SELECT /*+ index(PPA PAY_PAYROLL_ACTIONS_PK) */ paf_pri.assignment_id,
935: paf_pri.person_id,
936: paf_pri.period_of_service_id
937: FROM per_assignments_f paf,
938: per_assignments_f paf_pri,
936: paf_pri.period_of_service_id
937: FROM per_assignments_f paf,
938: per_assignments_f paf_pri,
939: pay_assignment_actions paa,
940: pay_payroll_actions ppa,
941: pay_population_ranges ppr
942: WHERE paf.assignment_id = paa.assignment_id
943: AND paa.tax_unit_id = cp_gre_id
944: AND ppr.payroll_action_id = p_payroll_action_id
968: paf_pri.period_of_service_id
969: FROM per_assignments_f paf,
970: per_assignments_f paf_pri,
971: pay_assignment_actions paa,
972: pay_payroll_actions ppa,
973: pay_all_payrolls_f pap
974: WHERE ppa.business_group_id + 0 = cp_bg_id
975: AND ppa.effective_date BETWEEN cp_start_date
976: AND cp_end_date
1001: cp_end_date DATE,
1002: cp_legal_employer_id NUMBER) IS
1003: SELECT ppa1.effective_date,
1004: paa1.assignment_action_id
1005: FROM pay_payroll_actions ppa1,
1006: pay_assignment_actions paa1,
1007: per_assignments_f paf1
1008: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
1009: AND paa1.assignment_id = paf1.assignment_id
1025: cp_prev_arch_eff_date DATE,
1026: cp_start_date DATE,
1027: cp_end_date DATE) IS
1028: SELECT 'Y'
1029: FROM pay_payroll_actions ppa2,
1030: pay_assignment_actions paa2,
1031: per_assignments_f paf2
1032: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
1033: AND ppa2.action_type IN ('R', 'Q', 'B', 'V', 'I')
1569: per_periods_of_service pps,
1570: hr_organization_units hou,
1571: hr_organization_information hoi,
1572: hr_locations_all hl,
1573: pay_payroll_actions ppa
1574: WHERE paa.assignment_action_id in
1575: (select assignment_action_id
1576: from pay_assignment_actions paa1
1577: where paa1.assignment_id = paf.assignment_id
1659: )
1660: FROM per_people_f ppf,
1661: per_assignments_f paf,
1662: pay_assignment_actions paa,
1663: pay_payroll_actions ppa,
1664: per_periods_of_service pps
1665: WHERE paa.assignment_action_id = p_archive_action_id
1666: AND ppa.payroll_action_id = paa.payroll_action_id
1667: AND paf.assignment_id = paa.assignment_id
1706: -- Date constraint relaxed since terminated assignments are also included.
1707: CURSOR c_get_ytd_aaid(cp_arch_period_start_date DATE,
1708: cp_arch_period_end_date DATE,
1709: cp_tax_unit_id NUMBER) IS
1710: select /*+ ordered index(PPA PAY_PAYROLL_ACTIONS_PK)*/ paa_all.assignment_action_id
1711: from pay_assignment_actions paa_pri ,
1712: per_assignments_f paf_pri ,
1713: per_assignments_f paf_all ,
1714: pay_assignment_actions paa_all,
1711: from pay_assignment_actions paa_pri ,
1712: per_assignments_f paf_pri ,
1713: per_assignments_f paf_all ,
1714: pay_assignment_actions paa_all,
1715: pay_payroll_actions ppa ,
1716: pay_action_classifications pac
1717: WHERE paa_pri.assignment_action_id = p_archive_action_id
1718: AND paf_pri.assignment_id = paa_pri.assignment_id
1719: AND paf_all.period_of_service_id = paf_pri.period_of_service_id
1800: cp_tax_unit_id NUMBER,
1801: cp_start_date DATE,
1802: cp_end_date DATE
1803: ) IS
1804: SELECT /*+ index(PPA PAY_PAYROLL_ACTIONS_PK)*/ DISTINCT ppa.effective_date
1805: FROM pay_run_results prr,
1806: pay_run_result_values prrv,
1807: pay_assignment_actions paa,
1808: pay_payroll_actions ppa,
1804: SELECT /*+ index(PPA PAY_PAYROLL_ACTIONS_PK)*/ DISTINCT ppa.effective_date
1805: FROM pay_run_results prr,
1806: pay_run_result_values prrv,
1807: pay_assignment_actions paa,
1808: pay_payroll_actions ppa,
1809: pay_input_values_f piv,
1810: pay_balance_feeds_f pbf,
1811: pay_balance_types pbt,
1812: per_assignments_f paf
1838: cp_start_date DATE,
1839: cp_end_date DATE,
1840: cp_tax_unit_id NUMBER) IS
1841: SELECT paa1.assignment_action_id, 'Y'
1842: FROM pay_payroll_actions ppa1,
1843: pay_assignment_actions paa1,
1844: per_assignments_f paf1,
1845: per_assignments_f paf2
1846: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
1865: FROM per_all_assignments_f paf
1866: WHERE paf.person_id = cp_person_id
1867: AND EXISTS ( SELECT 1
1868: FROM pay_assignment_actions paa
1869: ,pay_payroll_actions ppa
1870: WHERE paa.payroll_action_id = ppa.payroll_action_id
1871: AND ppa.action_type = 'B'
1872: AND ppa.effective_date BETWEEN trunc(cd_end_date,'Y')
1873: and cd_end_date
1884: ,legislative_parameters)
1885: ,paa.assignment_action_id
1886: FROM per_all_assignments_f paf
1887: ,pay_assignment_actions paa
1888: ,pay_payroll_actions ppa
1889: WHERE person_id = cp_person_id
1890: AND paa.payroll_action_id = ppa.payroll_action_id
1891: AND ppa.action_type = 'B'
1892: AND ppa.effective_date = cp_effective_date
1898:
1899: CURSOR c_pact_info ( cp_assignment_action_id NUMBER) IS
1900: select ppa.business_group_id
1901: ,ppa.effective_date
1902: from pay_payroll_actions ppa
1903: ,pay_assignment_actions paa
1904: where paa.assignment_action_id = cp_assignment_action_id
1905: and ppa.payroll_action_id = paa.payroll_action_id;
1906: