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 PER_ASSIGNMENTS_F

Line 841: per_assignments_f paf

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) || ''')
845: AND fnd_date.canonical_to_date(''' ||

Line 863: per_assignments_f paf

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) || ''')
867: AND fnd_date.canonical_to_date(''' ||

Line 881: per_assignments_f paf_all

877: AND EXISTS
878: (SELECT ''x''
879: FROM hr_assignment_sets has,
880: hr_assignment_set_amendments hasa,
881: per_assignments_f paf_all
882: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
883: AND has.assignment_set_id = hasa.assignment_set_id
884: AND hasa.assignment_id = paf_all.assignment_id
885: AND paf_all.person_id = paf.person_id

Line 925: FROM per_assignments_f paf,

921: WHERE has.assignment_set_id = cp_asg_set_id
922: AND has.assignment_set_id = hasa.assignment_set_id
923: AND hasa.assignment_id IN (SELECT DISTINCT
924: paf_all.assignment_id
925: FROM per_assignments_f paf,
926: per_assignments_f paf_all
927: WHERE paf.person_id = paf_all.person_id
928: AND paf.assignment_id = cp_asg_id)
929: AND hasa.include_or_exclude = 'E';

Line 926: per_assignments_f paf_all

922: AND has.assignment_set_id = hasa.assignment_set_id
923: AND hasa.assignment_id IN (SELECT DISTINCT
924: paf_all.assignment_id
925: FROM per_assignments_f paf,
926: per_assignments_f paf_all
927: WHERE paf.person_id = paf_all.person_id
928: AND paf.assignment_id = cp_asg_id)
929: AND hasa.include_or_exclude = 'E';
930:

Line 937: FROM per_assignments_f paf,

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,
939: pay_assignment_actions paa,
940: pay_payroll_actions ppa,
941: pay_population_ranges ppr

Line 938: per_assignments_f paf_pri,

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,
939: pay_assignment_actions paa,
940: pay_payroll_actions ppa,
941: pay_population_ranges ppr
942: WHERE paf.assignment_id = paa.assignment_id

Line 969: FROM per_assignments_f paf,

965: SELECT /*+ USE_NL(pap paf) */
966: paf_pri.assignment_id,
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

Line 970: per_assignments_f paf_pri,

966: paf_pri.assignment_id,
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

Line 1007: per_assignments_f paf1

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
1011: AND ppa1.report_type = 'MX_YREND_ARCHIVE'

Line 1031: per_assignments_f paf2

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
1035: AND paf2.period_of_service_id = cp_period_of_service_id

Line 1566: per_assignments_f paf,

1562: paa.tax_unit_id,
1563: cp_effective_date), 4),
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,

Line 1567: per_assignments_f paf_all,

1563: cp_effective_date), 4),
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,

Line 1661: per_assignments_f paf,

1657: NVL(pps.actual_termination_date,
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

Line 1712: per_assignments_f paf_pri ,

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 ,
1716: pay_action_classifications pac

Line 1713: per_assignments_f paf_all ,

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 ,
1716: pay_action_classifications pac
1717: WHERE paa_pri.assignment_action_id = p_archive_action_id

Line 1812: per_assignments_f paf

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
1813: WHERE pbt.balance_name = 'Profit Sharing'
1814: AND pbt.legislation_code = 'MX'
1815: AND pbf.balance_type_id = pbt.balance_type_id
1816: AND piv.input_value_id = pbf.input_value_id

Line 1844: per_assignments_f paf1,

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
1848: AND paf1.period_of_service_id = paf2.period_of_service_id

Line 1845: per_assignments_f paf2

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
1848: AND paf1.period_of_service_id = paf2.period_of_service_id
1849: AND paf2.assignment_id = cp_assignment_id