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 205: pay_payroll_actions ppa

201: -- Changed the cursor to reduce the cost (5042843)
202: p_sqlstr := 'SELECT distinct asg.person_id
203: FROM per_periods_of_service pos,
204: per_assignments_f asg,
205: pay_payroll_actions ppa
206: WHERE ppa.payroll_action_id = :payroll_action_id
207: AND pos.person_id = asg.person_id
208: AND pos.period_of_service_id = asg.period_of_service_id
209: AND pos.business_group_id = ppa.business_group_id

Line 241: pay_payroll_actions pa2,

237: act.assignment_id,
238: ppp.pre_payment_id
239: FROM pay_assignment_actions act,
240: per_all_assignments_f asg,
241: pay_payroll_actions pa2,
242: pay_payroll_actions pa1,
243: pay_pre_payments ppp,
244: pay_org_payment_methods_f OPM,
245: pay_payment_types PPT,

Line 242: pay_payroll_actions pa1,

238: ppp.pre_payment_id
239: FROM pay_assignment_actions act,
240: per_all_assignments_f asg,
241: pay_payroll_actions pa2,
242: pay_payroll_actions pa1,
243: pay_pre_payments ppp,
244: pay_org_payment_methods_f OPM,
245: pay_payment_types PPT,
246: per_all_people_f pap

Line 275: pay_payroll_actions appa

271: ))
272: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
273: FROM pay_action_interlocks pai1,
274: pay_assignment_actions act2,
275: pay_payroll_actions appa
276: WHERE pai1.locked_action_id = act.assignment_action_id
277: AND act2.assignment_action_id = pai1.locking_action_id
278: AND act2.payroll_action_id = appa.payroll_action_id
279: AND appa.action_type = 'X'