APPS.PAY_NO_UNION_DUES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 276: pay_assignment_actions assact

272: AND act_con.ASSIGNMENT_ACTION_ID = assact.ASSIGNMENT_ACTION_ID
273: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
274:
275: FROM
276: pay_assignment_actions assact
277: ,pay_assignment_actions assact1
278: ,pay_payroll_actions ppa
279: ,pay_payroll_actions ppa2
280: ,pay_payroll_actions ppa3

Line 277: ,pay_assignment_actions assact1

273: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
274:
275: FROM
276: pay_assignment_actions assact
277: ,pay_assignment_actions assact1
278: ,pay_payroll_actions ppa
279: ,pay_payroll_actions ppa2
280: ,pay_payroll_actions ppa3
281: ,per_all_assignments_f asg

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

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

Line 473: pay_assignment_actions assact

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

Line 602: FROM pay_assignment_actions

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