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 1176: l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;

1172: l_payroll_id number;
1173: l_assignment_id number;
1174: l_date date;
1175:
1176: l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;
1177: ischanged boolean;
1178:
1179: cursor get_payroll (cp_asg_act_id in number) is
1180: select ppa.payroll_id

Line 1183: pay_assignment_actions paa

1179: cursor get_payroll (cp_asg_act_id in number) is
1180: select ppa.payroll_id
1181: from
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa
1184: where paa.assignment_action_id = cp_asg_act_id
1185: and paa.payroll_action_id = ppa.payroll_action_id;
1186:
1187: cursor get_assignment_id (cp_asg_act_id in number) is

Line 1189: from pay_assignment_actions paa

1185: and paa.payroll_action_id = ppa.payroll_action_id;
1186:
1187: cursor get_assignment_id (cp_asg_act_id in number) is
1188: select assignment_id
1189: from pay_assignment_actions paa
1190: where paa.assignment_action_id = cp_asg_act_id;
1191:
1192: --
1193: -- A given assignment action is void if there is a payroll action of type 'D'

Line 1200: from pay_assignment_actions assact,

1196: -- a status of complete
1197: --
1198: cursor c_is_voided ( p_assignment_action_id in number ) is
1199: select intloc.locking_action_id
1200: from pay_assignment_actions assact,
1201: pay_action_interlocks intloc,
1202: pay_payroll_actions pact
1203: where intloc.locked_action_id = p_assignment_action_id
1204: and intloc.locking_action_id = assact.assignment_action_id

Line 1213: pay_assignment_actions paa

1209: cp_last_cc_run_date in date ) is
1210: select paa.assignment_action_id
1211: from
1212: pay_payroll_actions ppa,
1213: pay_assignment_actions paa
1214: where paa.assignment_action_id = p_assignment_action_id
1215: and paa.payroll_action_id = ppa.payroll_action_id
1216: and paa.action_status = 'C'
1217: and exists (select ''

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

1221: and ppe.creation_date > cp_last_cc_run_date
1222: and ppe.effective_date <= nvl(ppa.date_earned,ppa.effective_date)
1223: )
1224: and not exists (select ''
1225: from pay_assignment_actions paa1, -- Prepay/Costing
1226: pay_action_interlocks pai1,
1227: pay_assignment_actions paa2,-- Payment/Trans GL
1228: pay_action_interlocks pai2
1229: where pai1.locked_action_id = paa.assignment_action_id

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

1223: )
1224: and not exists (select ''
1225: from pay_assignment_actions paa1, -- Prepay/Costing
1226: pay_action_interlocks pai1,
1227: pay_assignment_actions paa2,-- Payment/Trans GL
1228: pay_action_interlocks pai2
1229: where pai1.locked_action_id = paa.assignment_action_id
1230: and pai1.locking_action_id = paa1.assignment_action_id
1231: and pai2.locked_action_id = paa1.assignment_action_id

Line 1239: pay_assignment_actions paa

1235: cp_last_cc_run_date in date ) is
1236: select paa.assignment_action_id
1237: from
1238: pay_payroll_actions ppa,
1239: pay_assignment_actions paa
1240: where paa.assignment_action_id = p_assignment_action_id
1241: and paa.payroll_action_id = ppa.payroll_action_id
1242: and paa.action_status = 'C'
1243: and not exists (select ''

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

1240: where paa.assignment_action_id = p_assignment_action_id
1241: and paa.payroll_action_id = ppa.payroll_action_id
1242: and paa.action_status = 'C'
1243: and not exists (select ''
1244: from pay_assignment_actions paa1, -- Payment/Trans GL
1245: pay_action_interlocks pai1
1246: where pai1.locked_action_id = paa.assignment_action_id
1247: and pai1.locking_action_id = paa1.assignment_action_id)
1248: and (exists (select ''

Line 1258: pay_assignment_actions paa2,

1254: )
1255: or
1256: exists (select ''
1257: from pay_action_interlocks pai,
1258: pay_assignment_actions paa2,
1259: pay_payroll_actions ppa2
1260: where pai.locking_action_id = paa.assignment_action_id
1261: and pai.locked_action_id = paa2.assignment_action_id
1262: and paa2.payroll_action_id = ppa2.payroll_action_id

Line 1279: pay_assignment_actions paa

1275: cp_last_cc_run_date in date ) is
1276: select paa.assignment_action_id
1277: from
1278: pay_payroll_actions ppa,
1279: pay_assignment_actions paa
1280: where paa.assignment_action_id = p_assignment_action_id
1281: and paa.payroll_action_id = ppa.payroll_action_id
1282: and paa.action_status = 'C'
1283: and not exists (select ''

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

1280: where paa.assignment_action_id = p_assignment_action_id
1281: and paa.payroll_action_id = ppa.payroll_action_id
1282: and paa.action_status = 'C'
1283: and not exists (select ''
1284: from pay_assignment_actions paa1, -- Payment/Trans GL
1285: pay_action_interlocks pai1
1286: where pai1.locked_action_id = paa.assignment_action_id
1287: and pai1.locking_action_id = paa1.assignment_action_id)
1288: and exists (select ''

Line 1297: pay_assignment_actions paa2,

1293: and ppe.creation_date > cp_last_cc_run_date
1294: )
1295: and exists (select ''
1296: from pay_action_interlocks pai,
1297: pay_assignment_actions paa2,
1298: pay_payroll_actions ppa2
1299: where pai.locking_action_id = paa.assignment_action_id
1300: and pai.locked_action_id = paa2.assignment_action_id
1301: and paa2.payroll_action_id = ppa2.payroll_action_id

Line 1952: pay_assignment_actions paa,

1948:
1949: select count(*)
1950: into run_counts
1951: from pay_payroll_actions ppa,
1952: pay_assignment_actions paa,
1953: pay_assignment_actions paa_curr
1954: where paa_curr.assignment_action_id = p_assact_id
1955: and paa.assignment_id = p_asg_id
1956: and paa.payroll_action_id = ppa.payroll_action_id

Line 1953: pay_assignment_actions paa_curr

1949: select count(*)
1950: into run_counts
1951: from pay_payroll_actions ppa,
1952: pay_assignment_actions paa,
1953: pay_assignment_actions paa_curr
1954: where paa_curr.assignment_action_id = p_assact_id
1955: and paa.assignment_id = p_asg_id
1956: and paa.payroll_action_id = ppa.payroll_action_id
1957: and paa.payroll_action_id <> paa_curr.payroll_action_id

Line 1971: pay_assignment_actions paa,

1967:
1968: select count(*)
1969: into run_counts
1970: from pay_payroll_actions ppa,
1971: pay_assignment_actions paa,
1972: pay_assignment_actions paa_curr
1973: where paa_curr.assignment_action_id = p_assact_id
1974: and paa.assignment_id = p_asg_id
1975: and paa.payroll_action_id = ppa.payroll_action_id

Line 1972: pay_assignment_actions paa_curr

1968: select count(*)
1969: into run_counts
1970: from pay_payroll_actions ppa,
1971: pay_assignment_actions paa,
1972: pay_assignment_actions paa_curr
1973: where paa_curr.assignment_action_id = p_assact_id
1974: and paa.assignment_id = p_asg_id
1975: and paa.payroll_action_id = ppa.payroll_action_id
1976: and paa.payroll_action_id <> paa_curr.payroll_action_id