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 626: FROM pay_assignment_actions paa,

622: IF ln_asg_set_id IS NULL THEN
623:
624: lv_sql_string :=
625: 'SELECT DISTINCT paf.person_id
626: FROM pay_assignment_actions paa,
627: pay_payroll_actions ppa,
628: per_assignments_f paf
629: WHERE ppa.business_group_id = ' || ln_business_group_id || '
630: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

Line 648: FROM pay_assignment_actions paa,

644: ELSE
645:
646: lv_sql_string :=
647: 'SELECT DISTINCT paf.person_id
648: FROM pay_assignment_actions paa,
649: pay_payroll_actions ppa,
650: per_assignments_f paf
651: WHERE ppa.business_group_id = ' || ln_business_group_id || '
652: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||

Line 725: pay_assignment_actions paa,

721: paf_pri.person_id,
722: paf_pri.period_of_service_id
723: FROM per_assignments_f paf,
724: per_assignments_f paf_pri,
725: pay_assignment_actions paa,
726: pay_payroll_actions ppa,
727: pay_population_ranges ppr
728: WHERE paf.assignment_id = paa.assignment_id
729: AND paa.tax_unit_id = cp_gre_id

Line 756: pay_assignment_actions paa,

752: paf_pri.person_id,
753: paf_pri.period_of_service_id
754: FROM per_assignments_f paf,
755: per_assignments_f paf_pri,
756: pay_assignment_actions paa,
757: pay_payroll_actions ppa,
758: pay_all_payrolls_f pap
759: WHERE ppa.business_group_id + 0 = cp_bg_id
760: AND ppa.effective_date BETWEEN cp_start_date

Line 789: pay_assignment_actions paa1,

785: cp_end_date DATE) IS
786: SELECT ppa1.effective_date,
787: paa1.assignment_action_id
788: FROM pay_payroll_actions ppa1,
789: pay_assignment_actions paa1,
790: per_assignments_f paf1
791: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
792: AND paa1.assignment_id = paf1.assignment_id
793: AND paf1.period_of_service_id = cp_period_of_service_id

Line 811: pay_assignment_actions paa2,

807: cp_start_date DATE,
808: cp_end_date DATE) IS
809: SELECT 'Y'
810: FROM pay_payroll_actions ppa2,
811: pay_assignment_actions paa2,
812: per_assignments_f paf2
813: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
814: AND ppa2.action_type IN ('R', 'Q', 'B', 'V', 'I')
815: AND paa2.assignment_id = paf2.assignment_id

Line 1002: SELECT pay_assignment_actions_s.NEXTVAL

998:
999: hr_utility.set_location(gv_package ||
1000: lv_procedure_name, 90);
1001:
1002: SELECT pay_assignment_actions_s.NEXTVAL
1003: INTO ln_yrend_action_id
1004: FROM dual;
1005:
1006: hr_nonrun_asact.insact(ln_yrend_action_id,

Line 1018: UPDATE pay_assignment_actions

1014:
1015: hr_utility.set_location(gv_package ||
1016: lv_procedure_name, 100);
1017:
1018: UPDATE pay_assignment_actions
1019: SET serial_number = ln_person_id
1020: WHERE assignment_action_id = ln_yrend_action_id;
1021:
1022: hr_utility.trace('Archiver asg action ' ||

Line 1055: SELECT pay_assignment_actions_s.NEXTVAL

1051:
1052: hr_utility.set_location(gv_package ||
1053: lv_procedure_name, 130);
1054:
1055: SELECT pay_assignment_actions_s.NEXTVAL
1056: INTO ln_yrend_action_id
1057: FROM dual;
1058:
1059: hr_utility.set_location(gv_package ||

Line 1074: UPDATE pay_assignment_actions

1070:
1071: hr_utility.set_location(gv_package ||
1072: lv_procedure_name, 150);
1073:
1074: UPDATE pay_assignment_actions
1075: SET serial_number = ln_person_id
1076: WHERE assignment_action_id = ln_yrend_action_id;
1077:
1078: hr_utility.trace('Archiver asg action ' ||

Line 1330: pay_assignment_actions paa,

1326: hl.region_1 "Jurisdiction"
1327: FROM per_people_f ppf,
1328: per_assignments_f paf,
1329: per_assignments_f paf_all,
1330: pay_assignment_actions paa,
1331: per_periods_of_service pps,
1332: hr_organization_units hou,
1333: hr_organization_information hoi,
1334: hr_locations_all hl,

Line 1338: from pay_assignment_actions

1334: hr_locations_all hl,
1335: pay_payroll_actions ppa
1336: WHERE paa.assignment_action_id in
1337: (select assignment_action_id
1338: from pay_assignment_actions
1339: where assignment_id in
1340: (select assignment_id
1341: from pay_assignment_actions
1342: where assignment_action_id = p_archive_action_id)

Line 1341: from pay_assignment_actions

1337: (select assignment_action_id
1338: from pay_assignment_actions
1339: where assignment_id in
1340: (select assignment_id
1341: from pay_assignment_actions
1342: where assignment_action_id = p_archive_action_id)
1343: and payroll_action_id = ppa.payroll_action_id )
1344: and not exists
1345: ( select 1 from pay_action_information

Line 1348: from pay_assignment_actions

1344: and not exists
1345: ( select 1 from pay_action_information
1346: where action_context_id in
1347: (select assignment_action_id
1348: from pay_assignment_actions
1349: where assignment_id in
1350: (select assignment_id
1351: from pay_assignment_actions
1352: where assignment_action_id = p_archive_action_id)

Line 1351: from pay_assignment_actions

1347: (select assignment_action_id
1348: from pay_assignment_actions
1349: where assignment_id in
1350: (select assignment_id
1351: from pay_assignment_actions
1352: where assignment_action_id = p_archive_action_id)
1353: and payroll_action_id = ppa.payroll_action_id) )
1354: and ppa.payroll_action_id = paa.payroll_action_id
1355: and paa.tax_unit_id in

Line 1419: pay_assignment_actions paa,

1415: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
1416: )
1417: FROM per_people_f ppf,
1418: per_assignments_f paf,
1419: pay_assignment_actions paa,
1420: pay_payroll_actions ppa,
1421: per_periods_of_service pps
1422: WHERE paa.assignment_action_id = p_archive_action_id
1423: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1465: FROM pay_assignment_actions paa_all,

1461: CURSOR c_get_ytd_aaid(cp_arch_period_start_date DATE,
1462: cp_arch_period_end_date DATE,
1463: cp_tax_unit_id NUMBER) IS
1464: SELECT paa_all.assignment_action_id
1465: FROM pay_assignment_actions paa_all,
1466: pay_assignment_actions paa_pri,
1467: pay_payroll_actions ppa,
1468: per_assignments_f paf_pri,
1469: per_assignments_f paf_all,

Line 1466: pay_assignment_actions paa_pri,

1462: cp_arch_period_end_date DATE,
1463: cp_tax_unit_id NUMBER) IS
1464: SELECT paa_all.assignment_action_id
1465: FROM pay_assignment_actions paa_all,
1466: pay_assignment_actions paa_pri,
1467: pay_payroll_actions ppa,
1468: per_assignments_f paf_pri,
1469: per_assignments_f paf_all,
1470: pay_action_classifications pac

Line 1561: pay_assignment_actions paa,

1557: ) IS
1558: SELECT DISTINCT ppa.effective_date
1559: FROM pay_run_results prr,
1560: pay_run_result_values prrv,
1561: pay_assignment_actions paa,
1562: pay_payroll_actions ppa,
1563: pay_input_values_f piv,
1564: pay_balance_feeds_f pbf,
1565: pay_balance_types pbt,

Line 1597: pay_assignment_actions paa1,

1593: cp_end_date DATE,
1594: cp_tax_unit_id NUMBER) IS
1595: SELECT paa1.assignment_action_id, 'Y'
1596: FROM pay_payroll_actions ppa1,
1597: pay_assignment_actions paa1,
1598: per_assignments_f paf1,
1599: per_assignments_f paf2
1600: WHERE ppa1.payroll_action_id = paa1.payroll_action_id
1601: AND paa1.assignment_id = paf1.assignment_id

Line 1622: FROM pay_assignment_actions paa

1618: SELECT distinct 'Y'
1619: FROM per_all_assignments_f paf
1620: WHERE paf.person_id = cp_person_id
1621: AND EXISTS ( SELECT 1
1622: FROM pay_assignment_actions paa
1623: ,pay_payroll_actions ppa
1624: WHERE paa.payroll_action_id = ppa.payroll_action_id
1625: AND ppa.action_type = 'B'
1626: AND ppa.effective_date BETWEEN trunc(cd_end_date,'Y')

Line 1641: ,pay_assignment_actions paa

1637: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
1638: ,legislative_parameters)
1639: ,paa.assignment_action_id
1640: FROM per_all_assignments_f paf
1641: ,pay_assignment_actions paa
1642: ,pay_payroll_actions ppa
1643: WHERE person_id = cp_person_id
1644: AND paa.payroll_action_id = ppa.payroll_action_id
1645: AND ppa.action_type = 'B'

Line 1657: ,pay_assignment_actions paa

1653: CURSOR c_pact_info ( cp_assignment_action_id NUMBER) IS
1654: select ppa.business_group_id
1655: ,ppa.effective_date
1656: from pay_payroll_actions ppa
1657: ,pay_assignment_actions paa
1658: where paa.assignment_action_id = cp_assignment_action_id
1659: and ppa.payroll_action_id = paa.payroll_action_id;
1660:
1661: CURSOR c_input_value_id IS