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_ASSIGNMENT_ACTIONS

Line 48: from pay_assignment_actions paa,

44: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
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

Line 50: pay_assignment_actions rpaa,

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
54: and paa.assignment_action_id =

Line 58: pay_assignment_actions aa

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
62: and aa.assignment_id = p_assignment_id

Line 68: from pay_assignment_actions aa,

64: and ppa.action_type in ('P', 'U')
65: and rpaa.assignment_id = p_assignment_id
66: and rpaa.action_sequence =
67: (select max(aa.action_sequence)
68: from pay_assignment_actions aa,
69: pay_action_interlocks loc
70: where loc.locked_action_id = aa.assignment_action_id
71: and aa.source_action_id is null
72: and loc.locking_action_id = paa.assignment_action_id); */

Line 82: from pay_assignment_actions paa,

78: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
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

Line 84: pay_assignment_actions rpaa,

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
88: and paa.assignment_action_id = curvar2

Line 93: from pay_assignment_actions aa,

89: and ppa.action_type in ('P', 'U')
90: and rpaa.assignment_id = p_assignment_id
91: and rpaa.action_sequence =
92: (select max(aa.action_sequence)
93: from pay_assignment_actions aa,
94: pay_action_interlocks loc
95: where loc.locked_action_id = aa.assignment_action_id
96: and aa.source_action_id is null
97: and loc.locking_action_id = paa.assignment_action_id);

Line 102: from pay_assignment_actions paa,

98: */
99: cursor cur_lat_action( curvar2 number)is
100: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
101: paa.assignment_action_id),16))
102: from pay_assignment_actions paa,
103: pay_action_interlocks loc
104: where loc.locked_action_id = paa.assignment_action_id
105: and paa.source_action_id IS NULL
106: and loc.locking_action_id = curvar2;

Line 111: from pay_assignment_actions rpaa,

107:
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:

Line 126: pay_assignment_actions aa

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
130: /*3922415-and ptp.payroll_id = pa.payroll_id*/

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 151: from pay_assignment_actions pac,

147:
148:
149: cursor csr_get_stand_run is
150: select pac.assignment_action_id
151: from pay_assignment_actions pac,
152: pay_run_types_f prt
153: where pac.run_type_id = prt.run_type_id
154: -- Added to be driven by index bug 2665701
155: and pac.assignment_id = p_assignment_id

Line 162: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

158:
159:
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;

Line 163: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

159:
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);

Line 271: from pay_assignment_actions assact,

267: -- if the action is a prepayment return the latest run details locked
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

Line 278: from pay_assignment_actions assact,

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
277: select assact.assignment_action_id
278: from pay_assignment_actions assact,
279: pay_action_interlocks loc
280: where loc.locking_action_id = p_assignment_action_id
281: and assact.assignment_action_id = loc.locked_action_id
282: and assact.source_action_id is null

Line 288: from pay_assignment_actions assact,

284: order by assact.action_sequence desc ;
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

Line 298: from pay_assignment_actions pac,

294: and pact.action_type in ('P','U') /* prepayments only */
295: order by assact.action_sequence desc ;
296: cursor csr_get_stand_run is
297: select pac.assignment_action_id
298: from pay_assignment_actions pac,
299: pay_run_types_f prt
300: where pac.run_type_id = prt.run_type_id
301: -- Added to be driven by index bug 2665701
302: and pac.assignment_id = p_assignment_id

Line 308: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

304: and prt.run_method='N';
305: --
306: l_action_type varchar2(1);
307: --
308: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
309: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
310: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
311: --
312: begin

Line 309: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

305: --
306: l_action_type varchar2(1);
307: --
308: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
309: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
310: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
311: --
312: begin
313: --