APPS.PAY_DK_PR_ASG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 362: ,pay_assignment_actions paa1

358: FROM
359: hr_assignment_set_amendments hasa
360: ,per_all_assignments_f paaf
361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1
365: ,pay_payroll_actions ppa2
366: ,pay_action_interlocks pai

Line 363: ,pay_assignment_actions paa2

359: hr_assignment_set_amendments hasa
360: ,per_all_assignments_f paaf
361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1
365: ,pay_payroll_actions ppa2
366: ,pay_action_interlocks pai
367: ,pay_run_results prr

Line 475: ,pay_assignment_actions paa1

471: FROM
472: -- hr_assignment_set_amendments hasa
473: per_all_assignments_f paaf
474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1
478: ,pay_payroll_actions ppa2
479: ,pay_action_interlocks pai

Line 476: ,pay_assignment_actions paa2

472: -- hr_assignment_set_amendments hasa
473: per_all_assignments_f paaf
474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1
478: ,pay_payroll_actions ppa2
479: ,pay_action_interlocks pai
480: ,pay_run_results prr

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

574: IF (csr_rec.pay_value > 0) THEN -- to archive only elements which have pay value > 0
575: --check for change of assignment id to create new assignment action id
576: IF (csr_rec.asg_act_id <> l_asg_act_id) THEN
577: BEGIN
578: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
579: EXCEPTION
580: WHEN OTHERS THEN
581: NULL ;
582: END ;

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

629: IF (csr_rec.pay_value > 0) THEN -- to archive only elements which have pay value > 0
630: --check for change of assignment id to create new assignment action id
631: IF (csr_rec.asg_act_id <> l_asg_act_id) THEN
632: BEGIN
633: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
634: EXCEPTION
635: WHEN OTHERS THEN
636: NULL ;
637: END ;

Line 721: ,pay_assignment_actions paa

717:
718: FROM
719: per_all_people_f papf
720: ,per_all_assignments_f paaf
721: ,pay_assignment_actions paa
722: ,per_jobs pj
723: ,hr_all_organization_units haou
724: WHERE
725:

Line 752: FROM pay_assignment_actions

748: END IF;
749: BEGIN
750: SELECT payroll_action_id
751: INTO l_payroll_action_id
752: FROM pay_assignment_actions
753: WHERE assignment_action_id = p_assignment_action_id ;
754: EXCEPTION
755: WHEN OTHERS THEN
756: NULL ;