APPS.PAY_IE_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 22: from pay_payroll_actions pa,

18: AND p_effective_date between asg.effective_start_date and asg.effective_end_date;
19:
20: CURSOR c_action_id(a_asg_id number) IS
21: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
22: from pay_payroll_actions pa,
23: pay_assignment_actions aa
24: where pa.action_type in ('U','P','Q','R')
25: and aa.action_status IN ('C','S') --10225372
26: and pa.payroll_action_id = aa.payroll_action_id

Line 112: ,PAY_PAYROLL_ACTIONS PPA

108: ,PTM.PERIOD_NUM COL16
109: ,Decode(PTPR.BASIC_PERIOD_TYPE,''CM'',PSPD.MONTHLY_STD_RATE_CUT_OFF*PTPR.NUMBER_PER_FISCAL_YEAR/12,''W'',PSPD.WEEKLY_STD_RATE_CUT_OFF*PTPR.NUMBER_PER_FISCAL_YEAR/52) COL17
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

Line 208: from PAY_PAYROLL_ACTIONS PPA

204: function set_cutoff_prompt(p_assignment_action_id NUMBER) return Varchar2 is
205: l_cutoff_prompt varchar2(50);
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

Line 231: from PAY_PAYROLL_ACTIONS PPA

227: function set_credit_prompt(p_assignment_action_id NUMBER) return Varchar2 is
228: l_credit_prompt varchar2(50);
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

Line 271: FROM pay_payroll_actions ppa,

267: /* Added number_per_fiscal_year for 4354386*/
268: CURSOR c_period_num_and_type (a_asg_action_id NUMBER)
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,