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 117: token_val pay_payroll_actions.legislative_parameters%TYPE;

113: ) RETURN VARCHAR2 IS
114:
115: start_ptr NUMBER;
116: end_ptr NUMBER;
117: token_val pay_payroll_actions.legislative_parameters%TYPE;
118: par_value pay_payroll_actions.legislative_parameters%TYPE;
119:
120: BEGIN
121:

Line 118: par_value pay_payroll_actions.legislative_parameters%TYPE;

114:
115: start_ptr NUMBER;
116: end_ptr NUMBER;
117: token_val pay_payroll_actions.legislative_parameters%TYPE;
118: par_value pay_payroll_actions.legislative_parameters%TYPE;
119:
120: BEGIN
121:
122: token_val := p_name || '=';

Line 177: leg_param pay_payroll_actions.legislative_parameters%TYPE;

173: l_procedure VARCHAR2(100) ;
174: l_message VARCHAR2(255);
175: --
176: l_payroll_id NUMBER;
177: leg_param pay_payroll_actions.legislative_parameters%TYPE;
178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
179: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
180: --
181: BEGIN

Line 178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;

174: l_message VARCHAR2(255);
175: --
176: l_payroll_id NUMBER;
177: leg_param pay_payroll_actions.legislative_parameters%TYPE;
178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
179: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
180: --
181: BEGIN
182: --

Line 179: l_pactid pay_payroll_actions.payroll_action_id%TYPE;

175: --
176: l_payroll_id NUMBER;
177: leg_param pay_payroll_actions.legislative_parameters%TYPE;
178: l_ppa_payroll_id pay_payroll_actions.payroll_id%TYPE;
179: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
180: --
181: BEGIN
182: --
183: l_procedure := g_package || 'initialization_code';

Line 189: -- Code to update the payroll_id in the pay_payroll_actions tabel.

185: g_debug := hr_utility.debug_enabled;
186: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
187:
188: --------------------------------------------------------------------------
189: -- Code to update the payroll_id in the pay_payroll_actions tabel.
190: --------------------------------------------------------------------------
191:
192: SELECT legislative_parameters,payroll_id
193: INTO leg_param,l_ppa_payroll_id

Line 194: FROM pay_payroll_actions

190: --------------------------------------------------------------------------
191:
192: SELECT legislative_parameters,payroll_id
193: INTO leg_param,l_ppa_payroll_id
194: FROM pay_payroll_actions
195: WHERE payroll_action_id = p_payroll_action_id ;
196:
197: l_payroll_id := get_parameter('PAYROLL', leg_param);
198:

Line 203: UPDATE pay_payroll_actions

199: -- Update the Payroll Action with the Payroll ID
200:
201: IF l_ppa_payroll_id IS NULL THEN
202:
203: UPDATE pay_payroll_actions
204: SET payroll_id = l_payroll_id
205: WHERE payroll_action_id = p_payroll_action_id;
206:
207: END IF;

Line 262: FROM pay_payroll_actions

258: INSTR(legislative_parameters,' ',
259: INSTR(legislative_parameters,p_token))
260: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
261: business_group_id
262: FROM pay_payroll_actions
263: WHERE payroll_action_id = p_pact_id;
264:
265: l_business_group_id VARCHAR2(20);
266: l_token_value VARCHAR2(50);

Line 361: pay_payroll_actions ppa_init,

357: p_consolidation_set_id NUMBER) IS
358: SELECT paa_init.assignment_id,
359: paa_init.assignment_action_id
360: FROM pay_assignment_actions paa_init,
361: pay_payroll_actions ppa_init,
362: per_all_assignments_f paf
363: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
364: AND ppa_init.action_type='I'
365: AND ppa_init.business_group_id = l_bg_id

Line 380: ,pay_payroll_actions ppa_arch

376: ,ppa_init.effective_date
377: )
378: AND NOT EXISTS (SELECT NULL
379: FROM pay_assignment_actions paa_arch
380: ,pay_payroll_actions ppa_arch
381: ,pay_action_interlocks intk
382: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
383: AND intk.locked_action_id = paa_init.assignment_action_id
384: AND intk.locking_action_id = paa_arch.assignment_action_id

Line 525: ,pay_payroll_actions ppa

521: ,pay_element_types_f pet
522: ,pay_element_links_f pel
523: ,pay_element_entries_f pee
524: ,pay_assignment_actions paa
525: ,pay_payroll_actions ppa
526: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
527: AND pel.element_type_id = pet.element_type_id
528: AND pee.element_link_id = pel.element_link_id
529: AND paa.assignment_id = pee.assignment_id

Line 716: ,pay_payroll_actions ppa

712: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
713: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
714: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
715: FROM pay_assignment_actions paa
716: ,pay_payroll_actions ppa
717: ,pay_run_results prr
718: ,pay_run_result_values prrv
719: ,per_time_periods ptp
720: ,pay_element_types_f pet

Line 1243: from pay_payroll_actions ppa

1239: CURSOR c_multi_rec_count(p_prepayment_lcking_id NUMBER
1240: )
1241: IS
1242: select count(paa.assignment_action_id)
1243: from pay_payroll_actions ppa
1244: ,pay_assignment_actions paa
1245: ,pay_action_interlocks pal
1246: where pal.locking_action_id=p_prepayment_lcking_id
1247: and paa.assignment_action_id=pal.locked_action_id

Line 1259: from pay_payroll_actions ppa

1255: IS
1256: select paa.assignment_action_id assignment_action_id
1257: ,ppa.date_earned date_earned
1258: ,ppa.effective_date effective_date
1259: from pay_payroll_actions ppa
1260: ,pay_assignment_actions paa
1261: ,pay_action_interlocks pal
1262: where pal.locking_action_id=p_prepayment_lcking_id
1263: and paa.assignment_action_id=pal.locked_action_id

Line 1276: ,pay_payroll_actions ppa

1272: CURSOR c_payroll_id(p_payroll_action_id NUMBER) IS
1273: SELECT payroll.payroll_id
1274: , payroll.payroll_name
1275: FROM pay_payrolls_f payroll
1276: ,pay_payroll_actions ppa
1277: WHERE ppa.payroll_action_id = p_run_payroll_action_id
1278: AND ppa.payroll_id = payroll.payroll_id;
1279:
1280: /*Added CURSOR c_med_added_to_net_pay for Bug 15951974 */

Line 1596: ,pay_payroll_actions ppa

1592: FROM hr_soft_coding_keyflex hsck
1593: ,hr_organization_information hoi
1594: ,per_assignments_f paaf
1595: ,pay_assignment_actions paa
1596: ,pay_payroll_actions ppa
1597: WHERE paa.assignment_action_id = p_assactid
1598: AND paa.payroll_action_id = ppa.payroll_action_id
1599: AND paa.assignment_id = paaf.assignment_id
1600: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 3292: FROM pay_payroll_actions

3288: --Cursor to find the effective date
3289: CURSOR c_effective_date(p_payroll_action_id NUMBER)
3290: IS
3291: SELECT effective_date
3292: FROM pay_payroll_actions
3293: WHERE payroll_action_id=p_payroll_action_id;
3294:
3295: --Cursor to find the PF/ESI Organization Name
3296: Cursor c_org_name(p_organization_id NUMBER

Line 3985: FROM pay_payroll_actions

3981: --Cursor to find the effective date
3982: CURSOR c_effective_date(p_payroll_action_id NUMBER)
3983: IS
3984: SELECT effective_date
3985: FROM pay_payroll_actions
3986: WHERE payroll_action_id = p_payroll_action_id;
3987:
3988: --Cursor to find the PT Organization Name
3989: Cursor c_org_name(p_organization_id NUMBER

Line 4262: ,pay_payroll_actions ppa_init

4258: ,paa_arch.assignment_id
4259: FROM pay_assignment_actions paa_arch
4260: ,pay_action_interlocks intk
4261: ,pay_assignment_actions paa_init
4262: ,pay_payroll_actions ppa_init
4263: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4264: AND intk.locking_action_id = paa_arch.assignment_action_id
4265: AND intk.locked_action_id = paa_init.assignment_action_id
4266: AND paa_init.payroll_action_id = ppa_init.payroll_action_id

Line 4293: ,pay_payroll_actions ppa_pre

4289: FROM pay_assignment_actions paa_arch_mst
4290: ,pay_assignment_actions paa_arch_chd
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run
4297: ,pay_payroll_actions ppa_run

Line 4297: ,pay_payroll_actions ppa_run

4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run
4297: ,pay_payroll_actions ppa_run
4298: ,per_time_periods ptp
4299: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4300: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
4301: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 4337: from pay_payroll_actions ppa

4333: CURSOR c_multi_rec_count(p_prepayment_lcking_id NUMBER
4334: )
4335: IS
4336: select count(paa.assignment_action_id)
4337: from pay_payroll_actions ppa
4338: ,pay_assignment_actions paa
4339: ,pay_action_interlocks pal
4340: where pal.locking_action_id=p_prepayment_lcking_id
4341: and paa.assignment_action_id=pal.locked_action_id

Line 4355: from pay_payroll_actions ppa

4351: )
4352: IS
4353: select paa.assignment_action_id
4354: ,ppa.date_earned
4355: from pay_payroll_actions ppa
4356: ,pay_assignment_actions paa
4357: ,pay_action_interlocks pal
4358: where pal.locking_action_id=p_prepayment_lcking_id
4359: and paa.assignment_action_id=pal.locked_action_id

Line 4373: FROM pay_payroll_actions ppa,pay_assignment_actions paa,

4369: ,c_assignment_id NUMBER
4370: ,c_payroll_date date)
4371: IS
4372: SELECT paa.assignment_action_id
4373: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4374: pay_action_interlocks pai1,pay_action_interlocks pai2
4375:
4376: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4377: AND paa.ASSIGNMENT_ID = c_assignment_id

Line 4394: FROM pay_payroll_actions ppa,

4390:
4391: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
4392: IS
4393: SELECT pps.actual_termination_date
4394: FROM pay_payroll_actions ppa,
4395: pay_assignment_actions paa,
4396: per_time_periods ptp,
4397: per_all_assignments_f paf,
4398: per_periods_of_service pps