APPS.PAY_IE_SOE dependencies on PER_TIME_PERIOD_TYPES

Line 115: ,PER_TIME_PERIOD_TYPES PTPT

111: from PAY_IE_SOE_PAYE_DETAILS_V PSPD
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

Line 211: ,PER_TIME_PERIOD_TYPES PTPT

207: select Decode(PTPR.BASIC_PERIOD_TYPE,'CM','Monthly Cutoff','W','Weekly Cutoff')
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

Line 234: ,PER_TIME_PERIOD_TYPES PTPT

230: select Decode(PTPR.BASIC_PERIOD_TYPE,'CM','Monthly Credit','W','Weekly Credit')
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

Line 274: per_time_period_types ptpt,

270: SELECT ptm.period_num, ptpr.basic_period_type, ptpr.number_per_fiscal_year
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