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.

[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 325: FROM pay_payroll_actions

321: pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
322: legislative_parameters) Legal_Employer_ID,
323: pay_mx_utility.get_parameter('TRANSFER_ASSIGNMENT_SET_ID',
324: legislative_parameters) Assignment_SET_ID
325: FROM pay_payroll_actions
326: WHERE payroll_action_id = cp_payroll_action_id;
327:
328: ld_end_date DATE;
329: ln_business_group_id NUMBER;

Line 627: pay_payroll_actions ppa,

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

Line 649: pay_payroll_actions ppa,

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

Line 726: pay_payroll_actions ppa,

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
730: AND ppr.payroll_action_id = p_payroll_action_id

Line 757: pay_payroll_actions ppa,

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
761: AND cp_end_date

Line 788: FROM pay_payroll_actions ppa1,

784: cp_start_date DATE,
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

Line 810: FROM pay_payroll_actions ppa2,

806: cp_prev_arch_eff_date DATE,
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')

Line 1335: pay_payroll_actions ppa

1331: per_periods_of_service pps,
1332: hr_organization_units hou,
1333: hr_organization_information hoi,
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

Line 1420: pay_payroll_actions ppa,

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
1424: AND paf.assignment_id = paa.assignment_id

Line 1467: pay_payroll_actions ppa,

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

Line 1562: pay_payroll_actions ppa,

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,
1566: per_assignments_f paf

Line 1596: FROM pay_payroll_actions ppa1,

1592: cp_start_date DATE,
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

Line 1623: ,pay_payroll_actions ppa

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')
1627: and cd_end_date

Line 1642: ,pay_payroll_actions ppa

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'
1646: AND ppa.effective_date = cp_effective_date

Line 1656: from pay_payroll_actions ppa

1652:
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: