APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_ASSIGNMENT_ACTIONS

Line 508: pay_assignment_actions assact

504: ,assact.TAX_UNIT_ID tax_unit_id
505: ,prr.LOCAL_UNIT_ID local_unit_id
506:
507: FROM
508: pay_assignment_actions assact
509: ,pay_assignment_actions assact1
510: ,pay_payroll_actions ppa
511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3

Line 509: ,pay_assignment_actions assact1

505: ,prr.LOCAL_UNIT_ID local_unit_id
506:
507: FROM
508: pay_assignment_actions assact
509: ,pay_assignment_actions assact1
510: ,pay_payroll_actions ppa
511: ,pay_payroll_actions ppa2
512: ,pay_payroll_actions ppa3
513: ,per_all_assignments_f asg

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

641: OPEN csr_tax_mun_id (rec_asg.asg_act_id , rec_asg.asg_id );
642: FETCH csr_tax_mun_id INTO l_tax_mun_id ;
643: CLOSE csr_tax_mun_id ;
644:
645: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
646:
647: -- Create the archive assignment action
648: hr_nonrun_asact.insact(l_actid ,rec_asg.asg_id ,p_payroll_action_id ,p_chunk ,NULL);
649:

Line 755: pay_assignment_actions assact

751: ,ppa.date_earned date_earned --date_earned to set the context
752: ,prr.source_id original_entry_id --source_id to set the context
753:
754: FROM
755: pay_assignment_actions assact
756: ,pay_payroll_actions ppa
757: ,per_all_assignments_f asg
758: ,per_all_people_f per
759: ,pay_run_results prr

Line 869: FROM pay_assignment_actions

865: END IF;
866:
867: SELECT payroll_action_id
868: INTO l_payroll_action_id
869: FROM pay_assignment_actions
870: WHERE assignment_action_id = p_assignment_action_id ;
871:
872:
873: -- fetch the data