APPS.PAY_NO_UNION_DUES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 277: pay_assignment_actions assact

273: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
274: ,prrv.result_value payee_id -- bug 14483053
275:
276: FROM
277: pay_assignment_actions assact
278: ,pay_assignment_actions assact1
279: ,pay_payroll_actions ppa
280: ,pay_payroll_actions ppa2
281: ,pay_payroll_actions ppa3

Line 278: ,pay_assignment_actions assact1

274: ,prrv.result_value payee_id -- bug 14483053
275:
276: FROM
277: pay_assignment_actions assact
278: ,pay_assignment_actions assact1
279: ,pay_payroll_actions ppa
280: ,pay_payroll_actions ppa2
281: ,pay_payroll_actions ppa3
282: ,per_all_assignments_f asg

Line 396: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

392: ,l_payee_org)
393: LOOP
394:
395: begin
396: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
397: exception
398: when others then
399: null;
400: end;

Line 475: pay_assignment_actions assact

471: ,prrv4.result_value res_val_4 -- Fixed Deduction Amount
472: ,prrv5.result_value res_val_5 -- Third Party Payee
473:
474: FROM
475: pay_assignment_actions assact
476: ,pay_payroll_actions ppa
477: ,per_all_assignments_f asg
478: ,per_all_people_f per
479: ,pay_element_types_f ele

Line 605: FROM pay_assignment_actions

601: END IF;
602: begin
603: SELECT payroll_action_id
604: INTO l_payroll_action_id
605: FROM pay_assignment_actions
606: WHERE assignment_action_id = p_assignment_action_id ;
607: exception
608: when others then
609: null;