DBA Data[Home] [Help]

APPS.PAY_IE_SOE dependencies on PER_TIME_PERIOD_RULES

Line 117: ,per_time_period_rules PTPR

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
121: and PAP.PAYROLL_ID = PTM.PAYROLL_ID

Line 213: ,per_time_period_rules PTPR

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
217: and PPA.DATE_EARNED BETWEEN PTM.START_DATE AND PTM.END_DATE -- 4906850

Line 236: ,per_time_period_rules PTPR

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
240: and PPA.DATE_EARNED BETWEEN PTM.START_DATE AND PTM.END_DATE -- 4906850

Line 276: per_time_period_rules ptpr

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
280: AND ppa.date_earned BETWEEN ptm.start_date AND ptm.end_date -- 4906850

Line 289: v_basic_period_type per_time_period_rules.basic_period_type%TYPE;

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;
293:

Line 290: v_number_per_fiscal_year per_time_period_rules.number_per_fiscal_year%TYPE;

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;
293:
294: begin