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_PAYROLL_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 55: FROM pay_payroll_actions

51: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
52: - (INSTR(legislative_parameters,
53: 'TRANSFER_PAYROLL_ID=')
54: + LENGTH('TRANSFER_PAYROLL_ID='))))))
55: FROM pay_payroll_actions
56: WHERE payroll_action_id = cp_payroll_action_id;
57:
58: ld_end_date DATE;
59: ld_start_date DATE;

Line 160: pay_payroll_actions ppa

156: CURSOR c_non_sep_check(cp_pymt_assignment_action_id IN NUMBER) IS
157: SELECT paa.assignment_action_id
158: FROM pay_action_interlocks pai,
159: pay_assignment_actions paa,
160: pay_payroll_actions ppa
161: WHERE pai.locking_action_id = cp_pymt_assignment_action_id
162: AND paa.assignment_action_id = pai.locked_action_id
163: AND paa.payroll_action_id = ppa.payroll_action_id
164: AND ppa.action_type IN ('Q','R')

Line 541: pay_payroll_actions ppa_pre,

537: pay_defined_balances pdb,
538: pay_run_balances prb,
539: pay_action_interlocks pai,
540: pay_assignment_actions paa_pre,
541: pay_payroll_actions ppa_pre,
542: pay_balance_types pbt_pri,
543: pay_balance_types pbt_sec,
544: pay_balance_types_tl pbtl
545: WHERE ppa_pre.action_type IN ('U', 'P')

Line 592: pay_payroll_actions ppa_pre,

588: pay_run_results prr,
589: pay_input_values_f piv,
590: pay_action_interlocks pai,
591: pay_assignment_actions paa_pre,
592: pay_payroll_actions ppa_pre,
593: pay_balance_types pbt_pri,
594: pay_balance_types pbt_sec,
595: pay_balance_types_tl pbtl
596: WHERE ppa_pre.action_type IN ('U', 'P')

Line 1377: pay_payroll_actions ppa

1373: pay_balance_types pbt_sec,
1374: pay_balance_types_tl pbtl,
1375: pay_run_balances prb,
1376: pay_assignment_actions paa,
1377: pay_payroll_actions ppa
1378: WHERE pbad.attribute_name IN ('Employee Earnings',
1379: 'Hourly Earnings',
1380: 'Deductions',
1381: 'Taxable Benefits'

Line 1428: pay_payroll_actions ppa

1424: pay_balance_types_tl pbtl,
1425: pay_run_results prr,
1426: pay_input_values_f piv,
1427: pay_assignment_actions paa,
1428: pay_payroll_actions ppa
1429: WHERE pbad.attribute_name IN ('Employee Earnings',
1430: 'Hourly Earnings',
1431: 'Deductions',
1432: 'Taxable Benefits'

Line 1480: pay_payroll_actions ppa

1476: pay_balance_types_tl pbtl,
1477: pay_run_balances prb,
1478: pay_assignment_actions paa,
1479: pay_action_interlocks pai,
1480: pay_payroll_actions ppa
1481: WHERE pbad.attribute_name IN ('Employee Earnings',
1482: 'Hourly Earnings',
1483: 'Deductions',
1484: 'Taxable Benefits'

Line 1533: pay_payroll_actions ppa

1529: pay_run_results prr,
1530: pay_input_values_f piv,
1531: pay_assignment_actions paa,
1532: pay_action_interlocks pai,
1533: pay_payroll_actions ppa
1534: WHERE pbad.attribute_name IN ('Employee Earnings',
1535: 'Hourly Earnings',
1536: 'Deductions',
1537: 'Taxable Benefits'

Line 1924: pay_payroll_actions ppa,

1920: pay_balance_types pbt_pri,
1921: pay_balance_types pbt_sec,
1922: pay_balance_types_tl pbtl,
1923: pay_assignment_actions paa,
1924: pay_payroll_actions ppa,
1925: pay_run_results prr,
1926: pay_input_values_f piv
1927: WHERE pbad.attribute_name IN ('Employee Earnings',
1928: 'Hourly Earnings',

Line 2242: pay_payroll_actions ppa,

2238:
2239: lv_sql_string :=
2240: 'SELECT DISTINCT paf.person_id
2241: FROM pay_assignment_actions paa,
2242: pay_payroll_actions ppa,
2243: per_assignments_f paf
2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 2265: pay_payroll_actions ppa1

2261: AND NOT EXISTS
2262: (SELECT ''x''
2263: FROM pay_action_interlocks pai,
2264: pay_assignment_actions paa1,
2265: pay_payroll_actions ppa1
2266: WHERE pai.locked_action_id = paa.assignment_action_id
2267: AND paa1.assignment_action_id = pai.locking_action_id
2268: AND ppa1.payroll_action_id = paa1.payroll_action_id
2269: AND ppa1.action_type =''X''

Line 2311: FROM pay_payroll_actions ppa,

2307: ppa.date_earned,
2308: ppa.action_type,
2309: paa.assignment_action_id,
2310: paa.payroll_action_id
2311: FROM pay_payroll_actions ppa,
2312: pay_assignment_actions paa,
2313: per_assignments_f paf
2314: WHERE paf.person_id BETWEEN cp_start_person_id
2315: AND cp_end_person_id

Line 2336: pay_payroll_actions ppa1

2332: AND NOT EXISTS
2333: (SELECT 'x'
2334: FROM pay_action_interlocks pai1,
2335: pay_assignment_actions paa1,
2336: pay_payroll_actions ppa1
2337: WHERE pai1.locked_action_id = paa.assignment_action_id
2338: AND paa1.assignment_action_id = pai1.locking_action_id
2339: AND ppa1.payroll_action_id = paa1.payroll_action_id
2340: AND ppa1.action_type ='X'

Line 2360: FROM pay_payroll_actions ppa,

2356: ppa.date_earned,
2357: ppa.action_type,
2358: paa.assignment_action_id,
2359: paa.payroll_action_id
2360: FROM pay_payroll_actions ppa,
2361: pay_assignment_actions paa,
2362: per_assignments_f paf,
2363: pay_population_ranges ppr
2364: WHERE ppr.payroll_action_id = cp_payroll_action_id

Line 2387: pay_payroll_actions ppa1

2383: AND NOT EXISTS
2384: (SELECT 'x'
2385: FROM pay_action_interlocks pai1,
2386: pay_assignment_actions paa1,
2387: pay_payroll_actions ppa1
2388: WHERE pai1.locked_action_id = paa.assignment_action_id
2389: AND paa1.assignment_action_id = pai1.locking_action_id
2390: AND ppa1.payroll_action_id = paa1.payroll_action_id
2391: AND ppa1.action_type ='X'

Line 2397: FROM pay_payroll_actions ppa,

2393: ORDER BY 1,2,3,5,6;
2394:
2395: CURSOR c_master_action(cp_prepayment_action_id NUMBER) IS
2396: SELECT MAX(paa.assignment_action_id)
2397: FROM pay_payroll_actions ppa,
2398: pay_assignment_actions paa,
2399: pay_action_interlocks pai
2400: WHERE pai.locking_action_Id = cp_prepayment_action_id
2401: AND paa.assignment_action_id = pai.locked_action_id

Line 3552: pay_payroll_actions ppa

3548: ,cp_assignment_id IN NUMBER) IS
3549: SELECT paa.assignment_action_id
3550: FROM pay_assignment_actions paa,
3551: pay_action_interlocks pai,
3552: pay_payroll_actions ppa
3553: WHERE pai.locking_action_id = cp_prepayment_action_id
3554: AND paa.assignment_action_id = pai.locked_action_id
3555: AND paa.assignment_id = cp_assignment_id
3556: AND ppa.payroll_action_id = paa.payroll_action_id

Line 3566: pay_payroll_actions ppa,

3562: SELECT ptp.time_period_id,
3563: ppa.date_earned,
3564: ppa.effective_date
3565: FROM pay_assignment_actions paa,
3566: pay_payroll_actions ppa,
3567: per_time_periods ptp
3568: WHERE paa.assignment_action_id = cp_run_assignment_action
3569: AND ppa.payroll_action_id = paa.payroll_action_id
3570: AND ptp.payroll_id = ppa.payroll_id

Line 4404: pay_payroll_actions ppa,

4400: pay_balance_types pbt_pri,
4401: pay_balance_types pbt_sec,
4402: pay_balance_types_tl pbtl,
4403: pay_assignment_actions paa,
4404: pay_payroll_actions ppa,
4405: pay_run_results prr,
4406: pay_input_values_f piv
4407: WHERE pbad.attribute_name IN ('Employee Earnings',
4408: 'Hourly Earnings',

Line 4760: pay_payroll_actions ppa

4756: CURSOR c_assignment_run (cp_prepayment_action_id IN NUMBER) IS
4757: SELECT DISTINCT paa.assignment_id
4758: FROM pay_action_interlocks pai,
4759: pay_assignment_actions paa,
4760: pay_payroll_actions ppa
4761: WHERE pai.locking_action_id = cp_prepayment_action_id
4762: AND paa.assignment_action_id = pai.locked_action_id
4763: AND ppa.payroll_action_id = paa.payroll_action_id
4764: AND ppa.action_type IN ('R', 'Q', 'B')

Line 4776: FROM pay_payroll_actions ppa,

4772: cp_prepayment_action_id IN NUMBER,
4773: cp_assignment_id IN NUMBER) IS
4774: SELECT paa.assignment_action_id, paa.payroll_action_id,
4775: ppa.action_type
4776: FROM pay_payroll_actions ppa,
4777: pay_assignment_actions paa,
4778: pay_action_interlocks pai
4779: WHERE pai.locking_action_id = cp_prepayment_action_id
4780: AND pai.locked_action_id = paa.assignment_action_id

Line 4788: FROM pay_payroll_actions ppa,

4784: ORDER BY paa.assignment_action_id DESC;
4785:
4786: CURSOR c_pymt_eff_date(cp_prepayment_action_id IN NUMBER) IS
4787: SELECT ppa.effective_date
4788: FROM pay_payroll_actions ppa,
4789: pay_assignment_actions paa
4790: WHERE ppa.payroll_action_id = paa.payroll_action_id
4791: AND paa.assignment_action_id = cp_prepayment_action_id;
4792: