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_CC_PROCESS_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 108: SELECT pay_assignment_actions_s.nextval

104: hr_utility.trace('>>> Last time CC was run for payroll '||l_payroll_id
105: ||' is: '||l_last_run_date);
106:
107: if (l_last_run_date < asgrec.creation_date) then
108: SELECT pay_assignment_actions_s.nextval
109: INTO l_lockingactid
110: FROM dual;
111: -- insert the action record.
112: hr_nonrun_asact.insact(l_lockingactid,asgrec.assignment_id,p_pactid,p_chunk, null);

Line 149: pay_assignment_actions paa

145: cursor get_dates (assact_id number, p_change_type varchar2) is
146: select nvl(min(ppe.effective_date), hr_api.g_eot)
147: effective_date
148: from pay_process_events ppe,
149: pay_assignment_actions paa
150: where paa.assignment_action_id = assact_id
151: and paa.assignment_id = ppe.assignment_id
152: and change_type = p_change_type;
153: --

Line 157: pay_assignment_actions paa,

153: --
154: cursor get_costings(p_assact_id number, p_effdate date) is
155: select paa.assignment_action_id
156: from pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: pay_assignment_actions paa_arch
159: where paa_arch.assignment_action_id = p_assact_id
160: and paa.assignment_id = paa_arch.assignment_id
161: and paa.action_status = 'C'

Line 158: pay_assignment_actions paa_arch

154: cursor get_costings(p_assact_id number, p_effdate date) is
155: select paa.assignment_action_id
156: from pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: pay_assignment_actions paa_arch
159: where paa_arch.assignment_action_id = p_assact_id
160: and paa.assignment_id = paa_arch.assignment_id
161: and paa.action_status = 'C'
162: and paa.payroll_action_id = ppa.payroll_action_id

Line 173: pay_assignment_actions paa,

169: --
170: cursor get_prepay(p_assact_id number, p_effdate date) is
171: select paa.assignment_action_id
172: from pay_payroll_actions ppa,
173: pay_assignment_actions paa,
174: pay_assignment_actions paa_arch
175: where paa_arch.assignment_action_id = p_assact_id
176: and paa.assignment_id = paa_arch.assignment_id
177: and paa.action_status = 'C'

Line 174: pay_assignment_actions paa_arch

170: cursor get_prepay(p_assact_id number, p_effdate date) is
171: select paa.assignment_action_id
172: from pay_payroll_actions ppa,
173: pay_assignment_actions paa,
174: pay_assignment_actions paa_arch
175: where paa_arch.assignment_action_id = p_assact_id
176: and paa.assignment_id = paa_arch.assignment_id
177: and paa.action_status = 'C'
178: and paa.payroll_action_id = ppa.payroll_action_id

Line 191: pay_assignment_actions paa,

187: select paa.assignment_action_id,
188: ppa.effective_date,
189: paa.assignment_id
190: from pay_payroll_actions ppa,
191: pay_assignment_actions paa,
192: pay_assignment_actions paa_arch
193: where paa_arch.assignment_action_id = p_assact_id
194: and paa.assignment_id = paa_arch.assignment_id
195: and paa.action_status in ('C', 'S')

Line 192: pay_assignment_actions paa_arch

188: ppa.effective_date,
189: paa.assignment_id
190: from pay_payroll_actions ppa,
191: pay_assignment_actions paa,
192: pay_assignment_actions paa_arch
193: where paa_arch.assignment_action_id = p_assact_id
194: and paa.assignment_id = paa_arch.assignment_id
195: and paa.action_status in ('C', 'S')
196: and paa.payroll_action_id = ppa.payroll_action_id

Line 202: pay_assignment_actions paa2,

198: and ppa.action_type in ('R', 'Q','V','B')
199: and ppa.effective_date >= p_effdate
200: and not exists (select ''
201: from pay_action_interlocks pai,
202: pay_assignment_actions paa2,
203: pay_payroll_actions ppa2,
204: pay_action_interlocks pai2
205: where pai.locked_action_id = paa.assignment_action_id
206: and pai.locking_action_id = paa2.assignment_action_id

Line 215: pay_assignment_actions ac2

211: and not exists (
212: select null
213: from pay_action_classifications acl,
214: pay_payroll_actions pa2,
215: pay_assignment_actions ac2
216: where ac2.assignment_id = paa.assignment_id
217: and pa2.payroll_action_id = ac2.payroll_action_id
218: and acl.classification_name = 'SEQUENCED'
219: and pa2.action_type = acl.action_type

Line 227: pay_assignment_actions ac2

223: and not exists (
224: select null
225: from pay_action_classifications acl,
226: pay_payroll_actions pa2,
227: pay_assignment_actions ac2
228: where ac2.assignment_id = paa.assignment_id
229: and pa2.payroll_action_id = ac2.payroll_action_id
230: and acl.classification_name = 'SEQUENCED'
231: and pa2.action_type = acl.action_type

Line 236: pay_assignment_actions paa2,

232: and pa2.action_type in ('R', 'Q','V','B')
233: and ac2.action_sequence > paa.action_sequence
234: and exists (select ''
235: from pay_action_interlocks pai,
236: pay_assignment_actions paa2,
237: pay_payroll_actions ppa2,
238: pay_action_interlocks pai2
239: where pai.locked_action_id = ac2.assignment_action_id
240: and pai.locking_action_id = paa2.assignment_action_id

Line 250: from pay_assignment_actions paa,

246: order by paa.action_sequence desc;
247: --
248: cursor get_locked_actions (p_assact_id number) is
249: select paa.assignment_action_id
250: from pay_assignment_actions paa,
251: pay_action_interlocks pai,
252: pay_payroll_actions ppa
253: where pai.locked_action_id = p_assact_id
254: and pai.locking_action_id = paa.assignment_action_id

Line 266: from pay_assignment_actions paa,

262: select
263: paa.assignment_id,
264: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters),
265: ppa.business_group_id
266: from pay_assignment_actions paa,
267: pay_payroll_actions ppa
268: where paa.payroll_action_id = ppa.payroll_action_id
269: and paa.assignment_action_id = cp_actid;
270:

Line 276: pay_assignment_actions paa,

272:
273: cursor csr_get_de_min(cp_assact_id number) is
274: select min(ppa.date_earned)
275: from pay_payroll_actions ppa,
276: pay_assignment_actions paa,
277: pay_assignment_actions paa_arch
278: where paa_arch.assignment_action_id = cp_assact_id
279: and paa.assignment_id = paa_arch.assignment_id
280: and paa.action_status in ('C', 'S')

Line 277: pay_assignment_actions paa_arch

273: cursor csr_get_de_min(cp_assact_id number) is
274: select min(ppa.date_earned)
275: from pay_payroll_actions ppa,
276: pay_assignment_actions paa,
277: pay_assignment_actions paa_arch
278: where paa_arch.assignment_action_id = cp_assact_id
279: and paa.assignment_id = paa_arch.assignment_id
280: and paa.action_status in ('C', 'S')
281: and paa.payroll_action_id = ppa.payroll_action_id

Line 287: pay_assignment_actions paa2,

283: and ppa.action_type in ('R', 'Q')
284: and not exists (
285: select 1
286: from pay_action_interlocks pai,
287: pay_assignment_actions paa2,
288: pay_payroll_actions ppa2,
289: pay_action_interlocks pai2
290: where pai.locked_action_id = paa.assignment_action_id
291: and pai.locking_action_id = paa2.assignment_action_id

Line 300: pay_assignment_actions ac2

296: and not exists (
297: select 1
298: from pay_action_classifications acl,
299: pay_payroll_actions pa2,
300: pay_assignment_actions ac2
301: where ac2.assignment_id = paa.assignment_id
302: and pa2.payroll_action_id = ac2.payroll_action_id
303: and acl.classification_name = 'SEQUENCED'
304: and pa2.action_type = acl.action_type

Line 315: , pay_assignment_actions paa

311: SELECT DISTINCT
312: prr.source_id entry
313: , pet.recalc_event_group_id event_group
314: FROM pay_run_results prr
315: , pay_assignment_actions paa
316: , pay_payroll_actions ppa
317: , pay_assignment_actions paa_arch
318: , pay_element_types_f pet
319: WHERE paa_arch.assignment_action_id = cp_assact_id

Line 317: , pay_assignment_actions paa_arch

313: , pet.recalc_event_group_id event_group
314: FROM pay_run_results prr
315: , pay_assignment_actions paa
316: , pay_payroll_actions ppa
317: , pay_assignment_actions paa_arch
318: , pay_element_types_f pet
319: WHERE paa_arch.assignment_action_id = cp_assact_id
320: and paa.assignment_id = paa_arch.assignment_id
321: AND prr.source_type = 'E'

Line 334: , pay_assignment_actions paa

330: SELECT DISTINCT
331: pee.element_entry_id entry
332: , pet.recalc_event_group_id event_group
333: FROM pay_element_entries_f pee
334: , pay_assignment_actions paa
335: , pay_element_links_f pel
336: , pay_element_types_f pet
337: WHERE paa.assignment_action_id = cp_assact_id
338: AND paa.assignment_id = pee.assignment_id

Line 539: pay_assignment_actions paa,

535:
536: select nvl(min(ppa.effective_date), hr_api.g_eot)
537: into l_aact_min_dedate_eff
538: from pay_payroll_actions ppa,
539: pay_assignment_actions paa,
540: pay_assignment_actions paa_arch
541: where paa_arch.assignment_action_id = p_assactid
542: and paa.assignment_id = paa_arch.assignment_id
543: and paa.payroll_action_id = ppa.payroll_action_id

Line 540: pay_assignment_actions paa_arch

536: select nvl(min(ppa.effective_date), hr_api.g_eot)
537: into l_aact_min_dedate_eff
538: from pay_payroll_actions ppa,
539: pay_assignment_actions paa,
540: pay_assignment_actions paa_arch
541: where paa_arch.assignment_action_id = p_assactid
542: and paa.assignment_id = paa_arch.assignment_id
543: and paa.payroll_action_id = ppa.payroll_action_id
544: and ppa.action_type in ('R', 'Q')

Line 1228: l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;

1224: l_payroll_id number;
1225: l_assignment_id number;
1226: l_date date;
1227:
1228: l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;
1229: ischanged boolean;
1230:
1231: cursor get_payroll (cp_asg_act_id in number) is
1232: select ppa.payroll_id

Line 1235: pay_assignment_actions paa

1231: cursor get_payroll (cp_asg_act_id in number) is
1232: select ppa.payroll_id
1233: from
1234: pay_payroll_actions ppa,
1235: pay_assignment_actions paa
1236: where paa.assignment_action_id = cp_asg_act_id
1237: and paa.payroll_action_id = ppa.payroll_action_id;
1238:
1239: cursor get_assignment_id (cp_asg_act_id in number) is

Line 1241: from pay_assignment_actions paa

1237: and paa.payroll_action_id = ppa.payroll_action_id;
1238:
1239: cursor get_assignment_id (cp_asg_act_id in number) is
1240: select assignment_id
1241: from pay_assignment_actions paa
1242: where paa.assignment_action_id = cp_asg_act_id;
1243:
1244: --
1245: -- A given assignment action is void if there is a payroll action of type 'D'

Line 1252: from pay_assignment_actions assact,

1248: -- a status of complete
1249: --
1250: cursor c_is_voided ( p_assignment_action_id in number ) is
1251: select intloc.locking_action_id
1252: from pay_assignment_actions assact,
1253: pay_action_interlocks intloc,
1254: pay_payroll_actions pact
1255: where intloc.locked_action_id = p_assignment_action_id
1256: and intloc.locking_action_id = assact.assignment_action_id

Line 1265: pay_assignment_actions paa

1261: cp_last_cc_run_date in date ) is
1262: select paa.assignment_action_id
1263: from
1264: pay_payroll_actions ppa,
1265: pay_assignment_actions paa
1266: where paa.assignment_action_id = p_assignment_action_id
1267: and paa.payroll_action_id = ppa.payroll_action_id
1268: and paa.action_status = 'C'
1269: and exists (select ''

Line 1277: from pay_assignment_actions paa1, -- Prepay/Costing

1273: and ppe.creation_date > cp_last_cc_run_date
1274: and ppe.effective_date <= nvl(ppa.date_earned,ppa.effective_date)
1275: )
1276: and not exists (select ''
1277: from pay_assignment_actions paa1, -- Prepay/Costing
1278: pay_action_interlocks pai1,
1279: pay_assignment_actions paa2,-- Payment/Trans GL
1280: pay_action_interlocks pai2
1281: where pai1.locked_action_id = paa.assignment_action_id

Line 1279: pay_assignment_actions paa2,-- Payment/Trans GL

1275: )
1276: and not exists (select ''
1277: from pay_assignment_actions paa1, -- Prepay/Costing
1278: pay_action_interlocks pai1,
1279: pay_assignment_actions paa2,-- Payment/Trans GL
1280: pay_action_interlocks pai2
1281: where pai1.locked_action_id = paa.assignment_action_id
1282: and pai1.locking_action_id = paa1.assignment_action_id
1283: and pai2.locked_action_id = paa1.assignment_action_id

Line 1291: pay_assignment_actions paa

1287: cp_last_cc_run_date in date ) is
1288: select paa.assignment_action_id
1289: from
1290: pay_payroll_actions ppa,
1291: pay_assignment_actions paa
1292: where paa.assignment_action_id = p_assignment_action_id
1293: and paa.payroll_action_id = ppa.payroll_action_id
1294: and paa.action_status = 'C'
1295: and not exists (select ''

Line 1296: from pay_assignment_actions paa1, -- Payment/Trans GL

1292: where paa.assignment_action_id = p_assignment_action_id
1293: and paa.payroll_action_id = ppa.payroll_action_id
1294: and paa.action_status = 'C'
1295: and not exists (select ''
1296: from pay_assignment_actions paa1, -- Payment/Trans GL
1297: pay_action_interlocks pai1
1298: where pai1.locked_action_id = paa.assignment_action_id
1299: and pai1.locking_action_id = paa1.assignment_action_id)
1300: and (exists (select ''

Line 1310: pay_assignment_actions paa2,

1306: )
1307: or
1308: exists (select ''
1309: from pay_action_interlocks pai,
1310: pay_assignment_actions paa2,
1311: pay_payroll_actions ppa2
1312: where pai.locking_action_id = paa.assignment_action_id
1313: and pai.locked_action_id = paa2.assignment_action_id
1314: and paa2.payroll_action_id = ppa2.payroll_action_id

Line 1331: pay_assignment_actions paa

1327: cp_last_cc_run_date in date ) is
1328: select paa.assignment_action_id
1329: from
1330: pay_payroll_actions ppa,
1331: pay_assignment_actions paa
1332: where paa.assignment_action_id = p_assignment_action_id
1333: and paa.payroll_action_id = ppa.payroll_action_id
1334: and paa.action_status = 'C'
1335: and not exists (select ''

Line 1336: from pay_assignment_actions paa1, -- Payment/Trans GL

1332: where paa.assignment_action_id = p_assignment_action_id
1333: and paa.payroll_action_id = ppa.payroll_action_id
1334: and paa.action_status = 'C'
1335: and not exists (select ''
1336: from pay_assignment_actions paa1, -- Payment/Trans GL
1337: pay_action_interlocks pai1
1338: where pai1.locked_action_id = paa.assignment_action_id
1339: and pai1.locking_action_id = paa1.assignment_action_id)
1340: and exists (select ''

Line 1349: pay_assignment_actions paa2,

1345: and ppe.creation_date > cp_last_cc_run_date
1346: )
1347: and exists (select ''
1348: from pay_action_interlocks pai,
1349: pay_assignment_actions paa2,
1350: pay_payroll_actions ppa2
1351: where pai.locking_action_id = paa.assignment_action_id
1352: and pai.locked_action_id = paa2.assignment_action_id
1353: and paa2.payroll_action_id = ppa2.payroll_action_id

Line 2027: pay_assignment_actions paa,

2023:
2024: select count(*)
2025: into run_counts
2026: from pay_payroll_actions ppa,
2027: pay_assignment_actions paa,
2028: pay_assignment_actions paa_curr
2029: where paa_curr.assignment_action_id = p_assact_id
2030: and paa.assignment_id = p_asg_id
2031: and paa.payroll_action_id = ppa.payroll_action_id

Line 2028: pay_assignment_actions paa_curr

2024: select count(*)
2025: into run_counts
2026: from pay_payroll_actions ppa,
2027: pay_assignment_actions paa,
2028: pay_assignment_actions paa_curr
2029: where paa_curr.assignment_action_id = p_assact_id
2030: and paa.assignment_id = p_asg_id
2031: and paa.payroll_action_id = ppa.payroll_action_id
2032: and paa.payroll_action_id <> paa_curr.payroll_action_id

Line 2046: pay_assignment_actions paa,

2042:
2043: select count(*)
2044: into run_counts
2045: from pay_payroll_actions ppa,
2046: pay_assignment_actions paa,
2047: pay_assignment_actions paa_curr
2048: where paa_curr.assignment_action_id = p_assact_id
2049: and paa.assignment_id = p_asg_id
2050: and paa.payroll_action_id = ppa.payroll_action_id

Line 2047: pay_assignment_actions paa_curr

2043: select count(*)
2044: into run_counts
2045: from pay_payroll_actions ppa,
2046: pay_assignment_actions paa,
2047: pay_assignment_actions paa_curr
2048: where paa_curr.assignment_action_id = p_assact_id
2049: and paa.assignment_id = p_asg_id
2050: and paa.payroll_action_id = ppa.payroll_action_id
2051: and paa.payroll_action_id <> paa_curr.payroll_action_id