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_PAYROLL_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 49: pay_payroll_actions ppa,

45: rpaa.payroll_action_id,
46: rpaa.assignment_action_id,
47: paa.assignment_action_id
48: from pay_assignment_actions paa,
49: pay_payroll_actions ppa,
50: pay_assignment_actions rpaa,
51: pay_payroll_actions rppa
52: where paa.payroll_action_id = ppa.payroll_action_id
53: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 51: pay_payroll_actions rppa

47: paa.assignment_action_id
48: from pay_assignment_actions paa,
49: pay_payroll_actions ppa,
50: pay_assignment_actions rpaa,
51: pay_payroll_actions rppa
52: where paa.payroll_action_id = ppa.payroll_action_id
53: and rppa.payroll_action_id = rpaa.payroll_action_id
54: and paa.assignment_action_id =
55: (select

Line 57: from pay_payroll_actions pa,

53: and rppa.payroll_action_id = rpaa.payroll_action_id
54: and paa.assignment_action_id =
55: (select
56: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
57: from pay_payroll_actions pa,
58: pay_assignment_actions aa
59: where pa.action_type in ('U','P')
60: and aa.action_status IN ('C','S') --10225372
61: and pa.payroll_action_id = aa.payroll_action_id

Line 83: pay_payroll_actions ppa,

79: rpaa.payroll_action_id,
80: rpaa.assignment_action_id,
81: paa.assignment_action_id
82: from pay_assignment_actions paa,
83: pay_payroll_actions ppa,
84: pay_assignment_actions rpaa,
85: pay_payroll_actions rppa
86: where paa.payroll_action_id = ppa.payroll_action_id
87: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 85: pay_payroll_actions rppa

81: paa.assignment_action_id
82: from pay_assignment_actions paa,
83: pay_payroll_actions ppa,
84: pay_assignment_actions rpaa,
85: pay_payroll_actions rppa
86: where paa.payroll_action_id = ppa.payroll_action_id
87: and rppa.payroll_action_id = rpaa.payroll_action_id
88: and paa.assignment_action_id = curvar2
89: and ppa.action_type in ('P', 'U')

Line 112: pay_payroll_actions rppa

108: cursor cur_pact_details(curvar3 number) IS
109: select to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
110: rpaa.payroll_action_id
111: from pay_assignment_actions rpaa,
112: pay_payroll_actions rppa
113: where rpaa.payroll_action_id = rppa.payroll_action_id
114: and rpaa.assignment_action_id = curvar3;
115:
116:

Line 125: from pay_payroll_actions pa,

121: ---before the date on which the payroll was run.It will display run results corresponding to prev.Payroll Run
122: ---in this case
123: cursor cur_assignment_action_id is
124: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
125: from pay_payroll_actions pa,
126: pay_assignment_actions aa
127: /*3922415- per_time_periods ptp */
128: where pa.action_type in ('Q','R','P','U')
129: and aa.action_status IN ('C','S') --10225372

Line 142: from pay_payroll_actions,pay_assignment_actions

138: ---This is used to retrive the actio_type corresponding to the assignment action id found by prev cursor
139:
140: cursor cur_action_type(curvar3 number) is
141: select distinct action_type
142: from pay_payroll_actions,pay_assignment_actions
143: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
144: and assignment_action_id =curvar3;
145:
146:

Line 143: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id

139:
140: cursor cur_action_type(curvar3 number) is
141: select distinct action_type
142: from pay_payroll_actions,pay_assignment_actions
143: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
144: and assignment_action_id =curvar3;
145:
146:
147:

Line 164: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

160: --
161: l_payroll_exists VARCHAR2(30);
162: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
163: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
164: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
165: l_date_earned VARCHAR2(30);
166: l_end_date date;
167: l_action_type varchar2(2);
168: --

Line 272: pay_payroll_actions pact

268: cursor csr_formula is
269: -- find what type of action this is
270: select pact.action_type , assact.assignment_id
271: from pay_assignment_actions assact,
272: pay_payroll_actions pact
273: where assact.assignment_action_id = p_assignment_action_id
274: and pact.payroll_action_id = assact.payroll_action_id;
275: cursor csr_formula_2 is
276: -- for prepayment action find the latest interlocked run

Line 289: pay_payroll_actions pact,

285: cursor csr_formula_3 is
286: -- for run action check if its been prepaid
287: select assact.assignment_action_id
288: from pay_assignment_actions assact,
289: pay_payroll_actions pact,
290: pay_action_interlocks loc
291: where loc.locked_action_id = p_assignment_action_id
292: and assact.assignment_action_id = loc.locking_action_id
293: and pact.payroll_action_id = assact.payroll_action_id