APPS.PAY_IE_SOE dependencies on PER_TIME_PERIODS

Line 114: ,PER_TIME_PERIODS PTM

110: ,Decode(PTPR.BASIC_PERIOD_TYPE,''CM'',PSPD.MONTHLY_TAX_CREDIT*PTPR.NUMBER_PER_FISCAL_YEAR/12,''W'',PSPD.WEEKLY_TAX_CREDIT*PTPR.NUMBER_PER_FISCAL_YEAR/52) COL18
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

Line 210: ,PER_TIME_PERIODS PTM

206: cursor get_cutoff is
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

Line 233: ,PER_TIME_PERIODS PTM

229: cursor get_credit is
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

Line 273: per_time_periods ptm,

269: IS
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

Line 288: v_period_num per_time_periods.period_num%TYPE;

284:
285:
286: v_contribution_class varchar2(60);
287: v_overridden_class varchar2(60);
288: v_period_num per_time_periods.period_num%TYPE;
289: v_basic_period_type per_time_period_rules.basic_period_type%TYPE;
290: v_number_per_fiscal_year per_time_period_rules.number_per_fiscal_year%TYPE;
291:
292: a_assignment_action_id number;