APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 26: FROM pay_payroll_actions

22: INSTR(legislative_parameters,' ',
23: INSTR(legislative_parameters,p_token))
24: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
25: business_group_id
26: FROM pay_payroll_actions
27: WHERE payroll_action_id = p_pact_id;
28:
29: l_business_group_id VARCHAR2(20);
30: l_token_value VARCHAR2(50);

Line 82: , pay_payroll_actions ppa

78: CURSOR CSR_BG_PAYPATH
79: IS
80: SELECT org.org_information8
81: FROM hr_organization_information org
82: , pay_payroll_actions ppa
83: WHERE
84: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
85: and org.organization_id = ppa.business_group_id
86: and org.org_information_context = 'IE_PAYPATH_INFORMATION'

Line 101: , pay_payroll_actions ppa

97: (SELECT to_number(segment2)
98: FROM
99: hr_soft_coding_keyflex sck
100: , pay_all_payrolls_f papf
101: , pay_payroll_actions ppa
102: WHERE
103: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
104: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
105: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

Line 229: pay_payroll_actions ppa

225: -- Changed the cursor to reduce the cost (5042843)
226: p_sqlstr := 'SELECT distinct asg.person_id
227: FROM per_periods_of_service pos,
228: per_assignments_f asg,
229: pay_payroll_actions ppa
230: WHERE ppa.payroll_action_id = :payroll_action_id
231: AND pos.person_id = asg.person_id
232: AND pos.period_of_service_id = asg.period_of_service_id
233: AND pos.business_group_id = ppa.business_group_id

Line 265: pay_payroll_actions pa2,

261: act.assignment_id,
262: ppp.pre_payment_id
263: FROM pay_assignment_actions act,
264: per_all_assignments_f asg,
265: pay_payroll_actions pa2,
266: pay_payroll_actions pa1,
267: pay_pre_payments ppp,
268: pay_org_payment_methods_f OPM,
269: pay_payment_types PPT,

Line 266: pay_payroll_actions pa1,

262: ppp.pre_payment_id
263: FROM pay_assignment_actions act,
264: per_all_assignments_f asg,
265: pay_payroll_actions pa2,
266: pay_payroll_actions pa1,
267: pay_pre_payments ppp,
268: pay_org_payment_methods_f OPM,
269: pay_payment_types PPT,
270: per_all_people_f pap

Line 299: pay_payroll_actions appa

295: ))
296: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
297: FROM pay_action_interlocks pai1,
298: pay_assignment_actions act2,
299: pay_payroll_actions appa
300: WHERE pai1.locked_action_id = act.assignment_action_id
301: AND act2.assignment_action_id = pai1.locking_action_id
302: AND act2.payroll_action_id = appa.payroll_action_id
303: AND appa.action_type = 'X'

Line 397: From pay_payroll_actions

393:
394: CURSOR c_get_bus_grp
395: IS
396: Select business_group_id
397: From pay_payroll_actions
398: Where payroll_action_id = p_payroll_action_id;
399:
400: CURSOR c_get_trx_date
401: IS

Line 403: From pay_payroll_actions

399:
400: CURSOR c_get_trx_date
401: IS
402: Select overriding_dd_date
403: From pay_payroll_actions
404: Where payroll_action_id = p_payroll_action_id;
405:
406: CURSOR c_get_conc_ident
407: IS