APPS.PAY_NO_TAX_LEVY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 272: pay_assignment_actions assact

268: AND act_con.ASSIGNMENT_ACTION_ID = assact.ASSIGNMENT_ACTION_ID
269: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
270:
271: FROM
272: pay_assignment_actions assact
273: ,pay_assignment_actions assact1
274: ,pay_payroll_actions ppa
275: ,pay_payroll_actions ppa2
276: ,pay_payroll_actions ppa3

Line 273: ,pay_assignment_actions assact1

269: AND act_con.ASSIGNMENT_ID = assact.ASSIGNMENT_ID) tax_mun_id
270:
271: FROM
272: pay_assignment_actions assact
273: ,pay_assignment_actions assact1
274: ,pay_payroll_actions ppa
275: ,pay_payroll_actions ppa2
276: ,pay_payroll_actions ppa3
277: ,per_all_assignments_f asg

Line 340: SELECT pay_assignment_actions_s.NEXTVAL FROM dual;

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

Line 482: pay_assignment_actions assact

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

Line 586: FROM pay_assignment_actions

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