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

Line 192: FROM pay_payroll_actions

188: INSTR(legislative_parameters,' ',
189: INSTR(legislative_parameters,p_token))
190: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
191: business_group_id
192: FROM pay_payroll_actions
193: WHERE payroll_action_id = p_pact_id;
194:
195: l_business_group_id VARCHAR2(20);
196: l_token_value VARCHAR2(50);

Line 291: pay_payroll_actions ppa_init,

287: p_consolidation_set_id NUMBER) IS
288: SELECT paa_init.assignment_id,
289: paa_init.assignment_action_id
290: FROM pay_assignment_actions paa_init,
291: pay_payroll_actions ppa_init,
292: per_all_assignments_f paf
293: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
294: AND ppa_init.action_type='I'
295: AND ppa_init.business_group_id = l_bg_id

Line 310: ,pay_payroll_actions ppa_arch

306: ,ppa_init.effective_date
307: )
308: AND NOT EXISTS (SELECT NULL
309: FROM pay_assignment_actions paa_arch
310: ,pay_payroll_actions ppa_arch
311: ,pay_action_interlocks intk
312: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
313: AND intk.locked_action_id = paa_init.assignment_action_id
314: AND intk.locking_action_id = paa_arch.assignment_action_id

Line 455: ,pay_payroll_actions ppa

451: ,pay_element_types_f pet
452: ,pay_element_links_f pel
453: ,pay_element_entries_f pee
454: ,pay_assignment_actions paa
455: ,pay_payroll_actions ppa
456: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
457: AND pel.element_type_id = pet.element_type_id
458: AND pee.element_link_id = pel.element_link_id
459: AND paa.assignment_id = pee.assignment_id

Line 646: ,pay_payroll_actions ppa

642: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
643: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
644: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
645: FROM pay_assignment_actions paa
646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp
650: ,pay_element_types_f pet

Line 1170: from pay_payroll_actions ppa

1166: CURSOR c_multi_rec_count(p_prepayment_lcking_id NUMBER
1167: )
1168: IS
1169: select count(paa.assignment_action_id)
1170: from pay_payroll_actions ppa
1171: ,pay_assignment_actions paa
1172: ,pay_action_interlocks pal
1173: where pal.locking_action_id=p_prepayment_lcking_id
1174: and paa.assignment_action_id=pal.locked_action_id

Line 1186: from pay_payroll_actions ppa

1182: IS
1183: select paa.assignment_action_id assignment_action_id
1184: ,ppa.date_earned date_earned
1185: ,ppa.effective_date effective_date
1186: from pay_payroll_actions ppa
1187: ,pay_assignment_actions paa
1188: ,pay_action_interlocks pal
1189: where pal.locking_action_id=p_prepayment_lcking_id
1190: and paa.assignment_action_id=pal.locked_action_id

Line 1203: ,pay_payroll_actions ppa

1199: CURSOR c_payroll_id(p_payroll_action_id NUMBER) IS
1200: SELECT payroll.payroll_id
1201: , payroll.payroll_name
1202: FROM pay_payrolls_f payroll
1203: ,pay_payroll_actions ppa
1204: WHERE ppa.payroll_action_id = p_run_payroll_action_id
1205: AND ppa.payroll_id = payroll.payroll_id;
1206:
1207: l_action_info_id NUMBER;

Line 1467: ,pay_payroll_actions ppa

1463: FROM hr_soft_coding_keyflex hsck
1464: ,hr_organization_information hoi
1465: ,per_assignments_f paaf
1466: ,pay_assignment_actions paa
1467: ,pay_payroll_actions ppa
1468: WHERE paa.assignment_action_id = p_assactid
1469: AND paa.payroll_action_id = ppa.payroll_action_id
1470: AND paa.assignment_id = paaf.assignment_id
1471: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 3080: FROM pay_payroll_actions

3076: --Cursor to find the effective date
3077: CURSOR c_effective_date(p_payroll_action_id NUMBER)
3078: IS
3079: SELECT effective_date
3080: FROM pay_payroll_actions
3081: WHERE payroll_action_id=p_payroll_action_id;
3082:
3083: --Cursor to find the PF/ESI Organization Name
3084: Cursor c_org_name(p_organization_id NUMBER

Line 3765: FROM pay_payroll_actions

3761: --Cursor to find the effective date
3762: CURSOR c_effective_date(p_payroll_action_id NUMBER)
3763: IS
3764: SELECT effective_date
3765: FROM pay_payroll_actions
3766: WHERE payroll_action_id = p_payroll_action_id;
3767:
3768: --Cursor to find the PT Organization Name
3769: Cursor c_org_name(p_organization_id NUMBER

Line 4042: ,pay_payroll_actions ppa_init

4038: ,paa_arch.assignment_id
4039: FROM pay_assignment_actions paa_arch
4040: ,pay_action_interlocks intk
4041: ,pay_assignment_actions paa_init
4042: ,pay_payroll_actions ppa_init
4043: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4044: AND intk.locking_action_id = paa_arch.assignment_action_id
4045: AND intk.locked_action_id = paa_init.assignment_action_id
4046: AND paa_init.payroll_action_id = ppa_init.payroll_action_id

Line 4074: ,pay_payroll_actions ppa_pre

4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4076: ,per_time_periods ptp
4077: ,per_business_groups pbg
4078: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id

Line 4075: ,pay_payroll_actions ppa_run

4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4076: ,per_time_periods ptp
4077: ,per_business_groups pbg
4078: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4079: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 4112: from pay_payroll_actions ppa

4108: CURSOR c_multi_rec_count(p_prepayment_lcking_id NUMBER
4109: )
4110: IS
4111: select count(paa.assignment_action_id)
4112: from pay_payroll_actions ppa
4113: ,pay_assignment_actions paa
4114: ,pay_action_interlocks pal
4115: where pal.locking_action_id=p_prepayment_lcking_id
4116: and paa.assignment_action_id=pal.locked_action_id

Line 4130: from pay_payroll_actions ppa

4126: )
4127: IS
4128: select paa.assignment_action_id
4129: ,ppa.date_earned
4130: from pay_payroll_actions ppa
4131: ,pay_assignment_actions paa
4132: ,pay_action_interlocks pal
4133: where pal.locking_action_id=p_prepayment_lcking_id
4134: and paa.assignment_action_id=pal.locked_action_id

Line 4148: FROM pay_payroll_actions ppa,pay_assignment_actions paa,

4144: ,c_assignment_id NUMBER
4145: ,c_payroll_date date)
4146: IS
4147: SELECT paa.assignment_action_id
4148: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4149: pay_action_interlocks pai1,pay_action_interlocks pai2
4150:
4151: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4152: AND paa.ASSIGNMENT_ID = c_assignment_id

Line 4169: FROM pay_payroll_actions ppa,

4165:
4166: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
4167: IS
4168: SELECT pps.actual_termination_date
4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa,
4171: per_time_periods ptp,
4172: per_all_assignments_f paf,
4173: per_periods_of_service pps