APPS.PAY_NO_TAX_LEVY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 273: pay_assignment_actions assact

269: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
270: ,prrv.result_value payee_id -- bug 14249180
271:
272: FROM
273: pay_assignment_actions assact
274: ,pay_assignment_actions assact1
275: ,pay_payroll_actions ppa
276: ,pay_payroll_actions ppa2
277: ,pay_payroll_actions ppa3

Line 274: ,pay_assignment_actions assact1

270: ,prrv.result_value payee_id -- bug 14249180
271:
272: FROM
273: pay_assignment_actions assact
274: ,pay_assignment_actions assact1
275: ,pay_payroll_actions ppa
276: ,pay_payroll_actions ppa2
277: ,pay_payroll_actions ppa3
278: ,per_all_assignments_f asg

Line 341: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;

337: ORDER BY assact.assignment_id ;
338:
339: --to get the next action_id
340: cursor csr_actid is
341: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;
342: ---------------------------------------------------------------------------------------------------------------
343: l_count NUMBER := 0;
344: l_action_info_id NUMBER;
345: l_ovn NUMBER;

Line 483: pay_assignment_actions assact

479: ,prrv4.result_value res_val_4 -- Fixed Deduction Amount
480: ,prrv5.result_value res_val_5 -- Third Party Payee
481:
482: FROM
483: pay_assignment_actions assact
484: ,pay_payroll_actions ppa
485: ,per_all_assignments_f asg
486: ,per_all_people_f per
487: ,pay_element_types_f ele

Line 588: FROM pay_assignment_actions

584:
585: --cursor to get the payroll_action_id
586: cursor csr_payroll_action_id is
587: SELECT payroll_action_id
588: FROM pay_assignment_actions
589: WHERE assignment_action_id = p_assignment_action_id ;
590:
591: --cursor to get the third party name
592: cursor csr_third_party_name is