DBA Data[Home] [Help]

APPS.PAY_DK_ABSR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 555: --,pay_assignment_actions paa

551: per_all_people_f papf
552: ,per_all_assignments_f paaf
553: ,pay_payrolls_f ppf
554: ,hr_soft_coding_keyflex scl
555: --,pay_assignment_actions paa
556: --,pay_payroll_actions ppa
557: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
558: AND papf.PERSON_ID = paaf.PERSON_ID
559: AND ppf.payroll_id = nvl(p_payroll_id,ppf.payroll_id)

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

988:
989: hr_utility.trace(' Inside if csr_rec.asg_id <> l_asgid after variable initialized');
990:
991: BEGIN
992: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
993: EXCEPTION
994: WHEN OTHERS THEN
995: NULL ;
996: END ;

Line 1227: Pay_assignment_actions paa,

1223: IS
1224: SELECT pai.*
1225: FROM
1226: pay_payroll_actions ppa,
1227: Pay_assignment_actions paa,
1228: pay_action_information pai
1229: WHERE
1230: ppa.payroll_action_id = p_payroll_action_id
1231: AND ppa.payroll_action_id = paa.payroll_action_id