eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 23: pay_assignment_actions aa

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 = 'C'
26: and pa.payroll_action_id = aa.payroll_action_id
27: and aa.assignment_id = a_asg_id

Line 113: ,PAY_ASSIGNMENT_ACTIONS PAAS

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
117: ,per_time_period_rules PTPR

Line 156: ,PAY_ASSIGNMENT_ACTIONS PAA

152: ,PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
153: ,PAY_INPUT_VALUES_F PIV
154: ,PAY_RUN_RESULT_VALUES PRV
155: ,PAY_RUN_RESULTS PRR
156: ,PAY_ASSIGNMENT_ACTIONS PAA
157: ,PAY_ELEMENT_SET_MEMBERS PESM
158: ,PAY_ELEMENT_SETS PES
159: WHERE PAA.ASSIGNMENT_ACTION_ID :action_clause
160: AND PEC.LEGISLATION_CODE = ''IE''

Line 209: ,PAY_ASSIGNMENT_ACTIONS PAAS

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
213: ,per_time_period_rules PTPR

Line 232: ,PAY_ASSIGNMENT_ACTIONS PAAS

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
236: ,per_time_period_rules PTPR

Line 254: select aa.assignment_action_id from pay_assignment_actions aa,pay_action_interlocks pai

250:
251: function Tax_PRSI_Info(p_assignment_action_id NUMBER) return long is
252:
253: Cursor c_pay_run(a_asg_action_id number) is
254: select aa.assignment_action_id from pay_assignment_actions aa,pay_action_interlocks pai
255: where locking_action_id=a_asg_action_id
256: and aa.assignment_action_id=locked_action_id
257: and aa.source_action_id is not null
258: and aa.action_status = 'C';

Line 272: pay_assignment_actions paas,

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,
276: per_time_period_rules ptpr