DBA Data[Home] [Help]

APPS.PAY_IE_SOE dependencies on PAY_ALL_PAYROLLS_F

Line 116: ,PAY_ALL_PAYROLLS_F pap

112: ,PAY_PAYROLL_ACTIONS PPA
113: ,PAY_ASSIGNMENT_ACTIONS PAAS
114: ,PER_TIME_PERIODS PTM
115: ,PER_TIME_PERIOD_TYPES PTPT
116: ,PAY_ALL_PAYROLLS_F pap
117: ,per_time_period_rules PTPR
118: where PSPD.assignment_action_id :action_clause
119: and PSPD.assignment_action_id=PAAS.ASSIGNMENT_ACTION_ID
120: and PAAS.PAYROLL_ACTION_ID=PPA.PAYROLL_ACTION_ID

Line 212: ,PAY_ALL_PAYROLLS_F pap

208: from PAY_PAYROLL_ACTIONS PPA
209: ,PAY_ASSIGNMENT_ACTIONS PAAS
210: ,PER_TIME_PERIODS PTM
211: ,PER_TIME_PERIOD_TYPES PTPT
212: ,PAY_ALL_PAYROLLS_F pap
213: ,per_time_period_rules PTPR
214: where PAAS.ASSIGNMENT_ACTION_ID = p_assignment_action_id
215: and PAAS.PAYROLL_ACTION_ID=PPA.PAYROLL_ACTION_ID
216: and PAP.PAYROLL_ID = PTM.PAYROLL_ID

Line 235: ,PAY_ALL_PAYROLLS_F pap

231: from PAY_PAYROLL_ACTIONS PPA
232: ,PAY_ASSIGNMENT_ACTIONS PAAS
233: ,PER_TIME_PERIODS PTM
234: ,PER_TIME_PERIOD_TYPES PTPT
235: ,PAY_ALL_PAYROLLS_F pap
236: ,per_time_period_rules PTPR
237: where Paas.assignment_action_id = p_assignment_action_id
238: and PAAS.PAYROLL_ACTION_ID=PPA.PAYROLL_ACTION_ID
239: and PAP.PAYROLL_ID = PTM.PAYROLL_ID

Line 275: pay_all_payrolls_f pap,

271: FROM pay_payroll_actions ppa,
272: pay_assignment_actions paas,
273: per_time_periods ptm,
274: per_time_period_types ptpt,
275: pay_all_payrolls_f pap,
276: per_time_period_rules ptpr
277: WHERE paas.assignment_action_id = a_asg_action_id
278: AND paas.payroll_action_id = ppa.payroll_action_id
279: AND pap.payroll_id = ptm.payroll_id