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 628: per_assignments_f paf

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(''' ||
631: fnd_date.date_to_canonical(ld_start_date) || ''')
632: AND fnd_date.canonical_to_date(''' ||

Line 650: per_assignments_f paf

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(''' ||
653: fnd_date.date_to_canonical(ld_start_date) || ''')
654: AND fnd_date.canonical_to_date(''' ||

Line 668: per_assignments_f paf_all

664: AND EXISTS
665: (SELECT ''x''
666: FROM hr_assignment_sets has,
667: hr_assignment_set_amendments hasa,
668: per_assignments_f paf_all
669: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
670: AND has.assignment_set_id = hasa.assignment_set_id
671: AND hasa.assignment_id = paf_all.assignment_id
672: AND paf_all.person_id = paf.person_id

Line 711: FROM per_assignments_f paf,

707: WHERE has.assignment_set_id = cp_asg_set_id
708: AND has.assignment_set_id = hasa.assignment_set_id
709: AND hasa.assignment_id IN (SELECT DISTINCT
710: paf_all.assignment_id
711: FROM per_assignments_f paf,
712: per_assignments_f paf_all
713: WHERE paf.person_id = paf_all.person_id
714: AND paf.assignment_id = cp_asg_id)
715: AND hasa.include_or_exclude = 'E';

Line 712: per_assignments_f paf_all

708: AND has.assignment_set_id = hasa.assignment_set_id
709: AND hasa.assignment_id IN (SELECT DISTINCT
710: paf_all.assignment_id
711: FROM per_assignments_f paf,
712: per_assignments_f paf_all
713: WHERE paf.person_id = paf_all.person_id
714: AND paf.assignment_id = cp_asg_id)
715: AND hasa.include_or_exclude = 'E';
716:

Line 723: FROM per_assignments_f paf,

719: cp_end_date DATE) IS
720: SELECT paf_pri.assignment_id,
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

Line 724: per_assignments_f paf_pri,

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

Line 754: FROM per_assignments_f paf,

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

Line 755: per_assignments_f paf_pri,

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

Line 790: per_assignments_f paf1

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

Line 812: per_assignments_f paf2

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

Line 1328: per_assignments_f paf,

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

Line 1329: per_assignments_f paf_all,

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

Line 1418: per_assignments_f paf,

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

Line 1468: per_assignments_f paf_pri,

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
1471: WHERE paa_pri.assignment_action_id = p_archive_action_id
1472: AND paf_pri.assignment_id = paa_pri.assignment_id

Line 1469: per_assignments_f paf_all,

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
1471: WHERE paa_pri.assignment_action_id = p_archive_action_id
1472: AND paf_pri.assignment_id = paa_pri.assignment_id
1473: AND paf_all.period_of_service_id = paf_pri.period_of_service_id

Line 1566: per_assignments_f paf

1562: pay_payroll_actions ppa,
1563: pay_input_values_f piv,
1564: pay_balance_feeds_f pbf,
1565: pay_balance_types pbt,
1566: per_assignments_f paf
1567: WHERE pbt.balance_name = 'Profit Sharing'
1568: AND pbt.legislation_code = 'MX'
1569: AND pbf.balance_type_id = pbt.balance_type_id
1570: AND piv.input_value_id = pbf.input_value_id

Line 1598: per_assignments_f paf1,

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

Line 1599: per_assignments_f paf2

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