APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 184: FROM pay_assignment_actions paa,

180:
181: CURSOR csr_locked_asgs
182: IS
183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,

Line 260: FROM pay_assignment_actions paa_p35,

256: )))
257: OR l_assignment_set_id IS NULL)
258: AND NOT EXISTS (
259: SELECT 1
260: FROM pay_assignment_actions paa_p35,
261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,

Line 280: AND plock.locked_action_id IN (SELECT assignment_action_id FROM pay_assignment_actions

276: --AND paa_p35.assignment_id = asg.assignment_id
277: AND paa_p35.assignment_id = paaf_p35.assignment_id
278: AND paaf_p35.person_id = paaf.person_id
279: AND paa_p35.assignment_action_id = plock.locking_action_id
280: AND plock.locked_action_id IN (SELECT assignment_action_id FROM pay_assignment_actions
281: WHERE assignment_id=paaf.assignment_id)
282: AND paaf_p35.payroll_id = ppf_p35.payroll_id
283: AND ppf_p35.soft_coding_keyflex_id = flex_p35.soft_coding_keyflex_id
284: AND flex_p35.segment4 = l_segment4);

Line 349: SELECT pay_assignment_actions_s.NEXTVAL

345: hr_utility.set_location ('Selected assignment ::'|| c_rec.assignment_id || ' ::and action ::passed to action creation::'||
346: c_rec.assignment_action_id||'::',960);
347: hr_utility.set_location ('Selected payroll_action::'||c_rec.payroll_action_id ,960);
348:
349: SELECT pay_assignment_actions_s.NEXTVAL
350: INTO l_actid
351: FROM DUAL;
352:
353: -- insert into pay_assignment_actions.

Line 353: -- insert into pay_assignment_actions.

349: SELECT pay_assignment_actions_s.NEXTVAL
350: INTO l_actid
351: FROM DUAL;
352:
353: -- insert into pay_assignment_actions.
354: hr_nonrun_asact.insact (
355: l_actid,
356: c_rec.assignment_id,
357: pactid,

Line 448: FROM pay_assignment_actions paa

444: sum(to_number(pact.action_information5))*100 EMPR_PRSA_BAL,
445: count(decode(pact.action_information6,0,null,null,null,1)) EMP_RAC,
446: sum(to_number(pact.action_information6))*100 EMP_RAC_BAL,
447: sum(to_number(pact.action_information1))*100 TAXABLEBENEFITS
448: FROM pay_assignment_actions paa
449: ,pay_action_information pact
450: ,pay_action_interlocks pai
451: WHERE paa.payroll_action_id = p_payroll_action_id
452: AND paa.source_action_id IS NULL