eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_YREND_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 839: FROM pay_assignment_actions paa,

835: IF ln_asg_set_id IS NULL THEN
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(''' ||

Line 861: FROM pay_assignment_actions paa,

857: ELSE
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(''' ||

Line 939: pay_assignment_actions paa,

935: paf_pri.person_id,
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

Line 971: pay_assignment_actions paa,

967: paf_pri.person_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

Line 1006: pay_assignment_actions paa1,

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
1010: AND paf1.period_of_service_id = cp_period_of_service_id

Line 1030: pay_assignment_actions paa2,

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')
1034: AND paa2.assignment_id = paf2.assignment_id

Line 1222: SELECT pay_assignment_actions_s.NEXTVAL

1218:
1219: hr_utility.set_location(gv_package ||
1220: lv_procedure_name, 90);
1221:
1222: SELECT pay_assignment_actions_s.NEXTVAL
1223: INTO ln_yrend_action_id
1224: FROM dual;
1225:
1226: hr_nonrun_asact.insact(ln_yrend_action_id,

Line 1238: UPDATE pay_assignment_actions

1234:
1235: hr_utility.set_location(gv_package ||
1236: lv_procedure_name, 100);
1237:
1238: UPDATE pay_assignment_actions
1239: SET serial_number = ln_person_id
1240: WHERE assignment_action_id = ln_yrend_action_id;
1241:
1242: hr_utility.trace('Archiver asg action ' ||

Line 1275: SELECT pay_assignment_actions_s.NEXTVAL

1271:
1272: hr_utility.set_location(gv_package ||
1273: lv_procedure_name, 130);
1274:
1275: SELECT pay_assignment_actions_s.NEXTVAL
1276: INTO ln_yrend_action_id
1277: FROM dual;
1278:
1279: hr_utility.set_location(gv_package ||

Line 1294: UPDATE pay_assignment_actions

1290:
1291: hr_utility.set_location(gv_package ||
1292: lv_procedure_name, 150);
1293:
1294: UPDATE pay_assignment_actions
1295: SET serial_number = ln_person_id
1296: WHERE assignment_action_id = ln_yrend_action_id;
1297:
1298: hr_utility.trace('Archiver asg action ' ||

Line 1528: FROM pay_assignment_actions

1524: CURSOR c_asg_action_details IS
1525: SELECT assignment_id,
1526: serial_number,
1527: tax_unit_id
1528: FROM pay_assignment_actions
1529: WHERE assignment_action_id = p_archive_action_id;
1530:
1531: -- Get employee details
1532: CURSOR c_emp_details(cp_effective_date DATE) IS

Line 1568: pay_assignment_actions paa,

1564: hl.region_1 "Jurisdiction"
1565: FROM per_people_f ppf,
1566: per_assignments_f paf,
1567: per_assignments_f paf_all,
1568: pay_assignment_actions paa,
1569: per_periods_of_service pps,
1570: hr_organization_units hou,
1571: hr_organization_information hoi,
1572: hr_locations_all hl,

Line 1576: from pay_assignment_actions paa1

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
1578: and paa1.assignment_id in
1579: (select assignment_id
1580: from pay_assignment_actions

Line 1580: from pay_assignment_actions

1576: from pay_assignment_actions paa1
1577: where paa1.assignment_id = paf.assignment_id
1578: and paa1.assignment_id in
1579: (select assignment_id
1580: from pay_assignment_actions
1581: where assignment_action_id = p_archive_action_id
1582: and assignment_id = paf.assignment_id)
1583: and payroll_action_id = ppa.payroll_action_id )
1584: and not exists

Line 1588: from pay_assignment_actions

1584: and not exists
1585: ( select 1 from pay_action_information
1586: where action_context_id in
1587: (select assignment_action_id
1588: from pay_assignment_actions
1589: where assignment_id in
1590: (select assignment_id
1591: from pay_assignment_actions
1592: where assignment_action_id = p_archive_action_id)

Line 1591: from pay_assignment_actions

1587: (select assignment_action_id
1588: from pay_assignment_actions
1589: where assignment_id in
1590: (select assignment_id
1591: from pay_assignment_actions
1592: where assignment_action_id = p_archive_action_id)
1593: and payroll_action_id = ppa.payroll_action_id) )
1594: and ppa.payroll_action_id = paa.payroll_action_id
1595: and paa.tax_unit_id in (SELECT DISTINCT gre_node.entity_id

Line 1662: pay_assignment_actions paa,

1658: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
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

Line 1711: from pay_assignment_actions paa_pri ,

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,
1715: pay_payroll_actions ppa ,

Line 1714: pay_assignment_actions paa_all,

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,
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

Line 1807: pay_assignment_actions paa,

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,
1809: pay_input_values_f piv,
1810: pay_balance_feeds_f pbf,
1811: pay_balance_types pbt,

Line 1843: pay_assignment_actions paa1,

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
1847: AND paa1.assignment_id = paf1.assignment_id

Line 1868: FROM pay_assignment_actions paa

1864: SELECT distinct 'Y'
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')

Line 1887: ,pay_assignment_actions paa

1883: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
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'

Line 1903: ,pay_assignment_actions paa

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:
1907: CURSOR c_input_value_id IS