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

Line 53: FROM pay_payroll_actions

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

Line 117: p_effective_date IN pay_payroll_actions.effective_date%TYPE

113: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
114: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
115: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
116: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
117: p_effective_date IN pay_payroll_actions.effective_date%TYPE
118: )
119: RETURN NUMBER
120: IS
121:

Line 743: pay_payroll_actions ppa_pre

739: pay_element_classifications pec,
740: pay_run_results prr,
741: pay_action_interlocks pai,
742: pay_assignment_actions paa_pre,
743: pay_payroll_actions ppa_pre
744: WHERE ppa_pre.action_type IN ('U', 'P')
745: AND ppa_pre.effective_date > cp_last_xfr_eff_date
746: AND ppa_pre.effective_date <= cp_last_pymt_eff_date
747: AND petf.element_type_id = prr.element_type_id

Line 1435: pay_payroll_actions ppa

1431: pay_element_types_f_tl petl,
1432: pay_element_classifications pec,
1433: pay_run_results prr,
1434: pay_assignment_actions paa,
1435: pay_payroll_actions ppa
1436: WHERE
1437: petf.element_type_id = prr.element_type_id
1438: AND pec.classification_id = petf.classification_id
1439: AND ppa.effective_date BETWEEN petf.effective_start_date

Line 1471: pay_payroll_actions ppa

1467: pay_element_classifications pec,
1468: pay_run_results prr,
1469: pay_assignment_actions paa,
1470: pay_action_interlocks pai,
1471: pay_payroll_actions ppa
1472: WHERE
1473: petf.element_type_id = prr.element_type_id
1474: AND pec.classification_id = petf.classification_id
1475: AND ppa.effective_date BETWEEN petf.effective_start_date

Line 1757: FROM pay_payroll_actions ppa

1753: ,NULL) amount
1754: ,get_element_payment_hours(prr.assignment_action_id, pet.element_type_id
1755: ,paf.pay_basis_id, prr.run_result_id, ppa.effective_date) hours
1756: ,pet.element_type_id element_type_id
1757: FROM pay_payroll_actions ppa
1758: ,pay_assignment_actions paa
1759: ,pay_run_results prr
1760: ,pay_run_result_values prrv
1761: ,pay_input_values_f piv

Line 1843: FROM pay_payroll_actions ppa

1839: ,NULL) amount
1840: ,get_element_payment_hours(prr.assignment_action_id, pet.element_type_id
1841: ,paf.pay_basis_id, prr.run_result_id, ppa.effective_date) hours
1842: ,pet.element_type_id element_type_id
1843: FROM pay_payroll_actions ppa
1844: ,pay_assignment_actions paa
1845: ,pay_run_results prr
1846: ,pay_run_result_values prrv
1847: ,pay_input_values_f piv

Line 2072: pay_payroll_actions ppa,

2068: FROM pay_element_types_f petf,
2069: pay_element_types_f_tl petl,
2070: pay_element_classifications pec,
2071: pay_assignment_actions paa,
2072: pay_payroll_actions ppa,
2073: pay_run_results prr
2074: WHERE petf.element_type_id = prr.element_type_id
2075: AND pec.classification_id = petf.classification_id
2076: AND petf.element_type_id = petl.element_type_id

Line 2303: pay_payroll_actions ppa,

2299:
2300: lv_sql_string :=
2301: 'SELECT DISTINCT paf.person_id
2302: FROM pay_assignment_actions paa,
2303: pay_payroll_actions ppa,
2304: per_assignments_f paf
2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 2326: pay_payroll_actions ppa1

2322: AND NOT EXISTS
2323: (SELECT ''x''
2324: FROM pay_action_interlocks pai,
2325: pay_assignment_actions paa1,
2326: pay_payroll_actions ppa1
2327: WHERE pai.locked_action_id = paa.assignment_action_id
2328: AND paa1.assignment_action_id = pai.locking_action_id
2329: AND ppa1.payroll_action_id = paa1.payroll_action_id
2330: AND ppa1.action_type =''X''

Line 2372: FROM pay_payroll_actions ppa,

2368: ppa.date_earned,
2369: ppa.action_type,
2370: paa.assignment_action_id,
2371: paa.payroll_action_id
2372: FROM pay_payroll_actions ppa,
2373: pay_assignment_actions paa,
2374: per_assignments_f paf
2375: WHERE paf.person_id BETWEEN cp_start_person_id
2376: AND cp_end_person_id

Line 2397: pay_payroll_actions ppa1

2393: AND NOT EXISTS
2394: (SELECT 'x'
2395: FROM pay_action_interlocks pai1,
2396: pay_assignment_actions paa1,
2397: pay_payroll_actions ppa1
2398: WHERE pai1.locked_action_id = paa.assignment_action_id
2399: AND paa1.assignment_action_id = pai1.locking_action_id
2400: AND ppa1.payroll_action_id = paa1.payroll_action_id
2401: AND ppa1.action_type ='X'

Line 2421: FROM pay_payroll_actions ppa,

2417: ppa.date_earned,
2418: ppa.action_type,
2419: paa.assignment_action_id,
2420: paa.payroll_action_id
2421: FROM pay_payroll_actions ppa,
2422: pay_assignment_actions paa,
2423: per_assignments_f paf,
2424: pay_population_ranges ppr
2425: WHERE ppr.payroll_action_id = cp_payroll_action_id

Line 2448: pay_payroll_actions ppa1

2444: AND NOT EXISTS
2445: (SELECT 'x'
2446: FROM pay_action_interlocks pai1,
2447: pay_assignment_actions paa1,
2448: pay_payroll_actions ppa1
2449: WHERE pai1.locked_action_id = paa.assignment_action_id
2450: AND paa1.assignment_action_id = pai1.locking_action_id
2451: AND ppa1.payroll_action_id = paa1.payroll_action_id
2452: AND ppa1.action_type ='X'

Line 2458: FROM pay_payroll_actions ppa,

2454: ORDER BY 1,2,3,5,6;
2455:
2456: CURSOR c_master_action(cp_prepayment_action_id NUMBER) IS
2457: SELECT MAX(paa.assignment_action_id)
2458: FROM pay_payroll_actions ppa,
2459: pay_assignment_actions paa,
2460: pay_action_interlocks pai
2461: WHERE pai.locking_action_Id = cp_prepayment_action_id
2462: AND paa.assignment_action_id = pai.locked_action_id

Line 2472: lv_action_type pay_payroll_actions.action_type%TYPE;

2468: ln_assignment_id NUMBER := 0;
2469: ln_tax_unit_id NUMBER := 0;
2470: ld_effective_date DATE;
2471: ld_date_earned DATE;
2472: lv_action_type pay_payroll_actions.action_type%TYPE;
2473: ln_asg_action_id NUMBER := 0;
2474: ln_payroll_action_id NUMBER := 0;
2475:
2476: ln_master_action_id NUMBER := 0;

Line 2772: FROM pay_payroll_actions WHERE payroll_action_id = p_payroll_action_id;

2768: j := 0;
2769: ln_step := 1;
2770:
2771: SELECT business_group_id INTO ln_business_group_id
2772: FROM pay_payroll_actions WHERE payroll_action_id = p_payroll_action_id;
2773:
2774: /*Setting legislation code global variable*/
2775: OPEN c_get_legislation_code (ln_business_group_id);
2776: FETCH c_get_legislation_code INTO lv_legislation_code;

Line 3370: ,pay_payroll_actions ppa

3366: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
3367: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
3368: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
3369: FROM pay_assignment_actions paa
3370: ,pay_payroll_actions ppa
3371: ,pay_run_results prr
3372: ,pay_run_result_values prrv
3373: ,per_time_periods ptp
3374: ,pay_element_types_f pet

Line 3708: pay_payroll_actions ppa

3704: ,cp_assignment_id IN NUMBER) IS
3705: SELECT paa.assignment_action_id
3706: FROM pay_assignment_actions paa,
3707: pay_action_interlocks pai,
3708: pay_payroll_actions ppa
3709: WHERE pai.locking_action_id = cp_prepayment_action_id
3710: AND paa.assignment_action_id = pai.locked_action_id
3711: AND paa.assignment_id = cp_assignment_id
3712: AND ppa.payroll_action_id = paa.payroll_action_id

Line 3722: pay_payroll_actions ppa,

3718: SELECT ptp.time_period_id,
3719: ppa.date_earned,
3720: ppa.effective_date
3721: FROM pay_assignment_actions paa,
3722: pay_payroll_actions ppa,
3723: per_time_periods ptp
3724: WHERE paa.assignment_action_id = cp_run_assignment_action
3725: AND ppa.payroll_action_id = paa.payroll_action_id
3726: AND ptp.payroll_id = ppa.payroll_id

Line 4141: pay_payroll_actions ppa

4137: CURSOR c_assignment_run (cp_prepayment_action_id IN NUMBER) IS
4138: SELECT DISTINCT paa.assignment_id
4139: FROM pay_action_interlocks pai,
4140: pay_assignment_actions paa,
4141: pay_payroll_actions ppa
4142: WHERE pai.locking_action_id = cp_prepayment_action_id
4143: AND paa.assignment_action_id = pai.locked_action_id
4144: AND ppa.payroll_action_id = paa.payroll_action_id
4145: AND ppa.action_type IN ('R', 'Q', 'B')

Line 4157: FROM pay_payroll_actions ppa,

4153: cp_prepayment_action_id IN NUMBER,
4154: cp_assignment_id IN NUMBER) IS
4155: SELECT paa.assignment_action_id, paa.payroll_action_id,
4156: ppa.action_type
4157: FROM pay_payroll_actions ppa,
4158: pay_assignment_actions paa,
4159: pay_action_interlocks pai
4160: WHERE pai.locking_action_id = cp_prepayment_action_id
4161: AND pai.locked_action_id = paa.assignment_action_id

Line 4169: FROM pay_payroll_actions ppa,

4165: ORDER BY paa.assignment_action_id DESC;
4166:
4167: CURSOR c_pymt_eff_date(cp_prepayment_action_id IN NUMBER) IS
4168: SELECT ppa.effective_date
4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa
4171: WHERE ppa.payroll_action_id = paa.payroll_action_id
4172: AND paa.assignment_action_id = cp_prepayment_action_id;
4173:

Line 4273: lv_master_action_type pay_payroll_actions.action_type%TYPE;

4269: ln_assignment_id NUMBER;
4270: ln_chunk_number NUMBER;
4271:
4272: lv_xfr_master_serial_number pay_assignment_actions.serial_number%TYPE;
4273: lv_master_action_type pay_payroll_actions.action_type%TYPE;
4274:
4275: lv_master_sepcheck_flag VARCHAR2(1);
4276: ln_asg_action_id NUMBER;
4277:

Line 4280: lv_master_run_action_type pay_payroll_actions.action_type%TYPE;

4276: ln_asg_action_id NUMBER;
4277:
4278: ln_master_run_action_id NUMBER;
4279: ln_master_run_pact_id NUMBER;
4280: lv_master_run_action_type pay_payroll_actions.action_type%TYPE;
4281:
4282: ln_pymt_balcall_aaid NUMBER;
4283: ln_pay_action_count NUMBER;
4284: