APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 595: ,pay_assignment_actions act

591: act1.assignment_action_id prepaid_action_id
592: FROM pay_payroll_actions ppa
593: ,pay_payroll_actions appa
594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1
597: ,pay_action_interlocks pai
598: ,per_all_assignments_f as1
599: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 596: ,pay_assignment_actions act1

592: FROM pay_payroll_actions ppa
593: ,pay_payroll_actions appa
594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1
597: ,pay_action_interlocks pai
598: ,per_all_assignments_f as1
599: WHERE ppa.payroll_action_id = p_payroll_action_id
600: AND appa.effective_date BETWEEN l_canonical_start_date

Line 681: SELECT pay_assignment_actions_s.NEXTVAL

677: LOOP
678: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
679: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
680:
681: SELECT pay_assignment_actions_s.NEXTVAL
682: INTO l_actid
683: FROM dual;
684:
685: -- Create the archive assignment action

Line 744: pay_assignment_actions pac,

740: SELECT pap.national_identifier cpr , pap.person_id , pac.assignment_id, pap.full_name,
741: pap.start_date, pap.business_group_id, assign.hourly_salaried_code HOURLY_SALARIED_CODE,
742: assign.assignment_number, assign.organization_id, assign.primary_flag
743: FROM
744: pay_assignment_actions pac,
745: per_all_assignments_f assign,
746: per_all_people_f pap
747: WHERE pac.assignment_action_id = p_asg_act_id
748: AND assign.assignment_id = pac.assignment_id

Line 896: ,pay_assignment_actions pac

892: ,p_end_date DATE
893: ,p_business_group_id NUMBER) IS
894: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
895: FROM per_all_assignments_f paa
896: ,pay_assignment_actions pac
897: WHERE pac.assignment_action_id = p_asg_act_id
898: AND paa.assignment_id = pac.assignment_id
899: AND paa.EFFECTIVE_START_DATE <= p_end_date
900: AND paa.EFFECTIVE_END_DATE > = p_start_date

Line 924: from pay_assignment_actions pac, pay_payroll_actions ppa

920: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
921:
922: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
923: select pac.ASSIGNMENT_ACTION_ID id
924: from pay_assignment_actions pac, pay_payroll_actions ppa
925: where ppa.action_type IN ('R','Q')
926: and pac.payroll_action_id = ppa.payroll_action_id
927: and pac.assignment_id= assg_id
928: and ppa.payroll_id=pid

Line 1078: FROM pay_assignment_actions

1074: BEGIN
1075:
1076: SELECT payroll_action_id
1077: INTO l_payroll_action_id
1078: FROM pay_assignment_actions
1079: WHERE assignment_action_id=p_assignment_action_id;
1080: END;
1081:
1082: IF g_debug THEN