APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 710: ,pay_assignment_actions act

706: act1.assignment_action_id prepaid_action_id
707: FROM pay_payroll_actions ppa
708: ,pay_payroll_actions appa
709: ,pay_payroll_actions appa2
710: ,pay_assignment_actions act
711: ,pay_assignment_actions act1
712: ,pay_action_interlocks pai
713: ,per_all_assignments_f as1
714: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 711: ,pay_assignment_actions act1

707: FROM pay_payroll_actions ppa
708: ,pay_payroll_actions appa
709: ,pay_payroll_actions appa2
710: ,pay_assignment_actions act
711: ,pay_assignment_actions act1
712: ,pay_action_interlocks pai
713: ,per_all_assignments_f as1
714: WHERE ppa.payroll_action_id = p_payroll_action_id
715: AND appa.effective_date BETWEEN l_canonical_start_date

Line 807: SELECT pay_assignment_actions_s.NEXTVAL

803: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
804: -- 13630274 -- AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
805: AND l_prev_assg_id <> rec_prepaid_assignments.assignment_id THEN
806:
807: SELECT pay_assignment_actions_s.NEXTVAL
808: INTO l_actid
809: FROM dual;
810:
811: -- Create the archive assignment action

Line 872: pay_assignment_actions pac,

868: pap.first_name||' '||pap.middle_names||' '||pap.last_name pname, pap.sex, pap.start_date, pap.business_group_id,
869: assign.hourly_salaried_code HOURLY_SALARIED_CODE, assign.assignment_number, assign.organization_id, assign.primary_flag,
870: assign.location_id
871: FROM
872: pay_assignment_actions pac,
873: per_all_assignments_f assign,
874: per_all_people_f pap
875: WHERE pac.assignment_action_id = p_asg_act_id
876: AND assign.assignment_id = pac.assignment_id

Line 1087: ,pay_assignment_actions pac

1083: ,p_end_date DATE
1084: ,p_business_group_id NUMBER) IS
1085: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
1086: FROM per_all_assignments_f paa
1087: ,pay_assignment_actions pac
1088: WHERE pac.assignment_action_id = p_asg_act_id
1089: AND paa.assignment_id = pac.assignment_id
1090: -- AND paa.EFFECTIVE_START_DATE <= p_end_date 10322958
1091: AND paa.EFFECTIVE_END_DATE > = p_start_date

Line 1115: from pay_assignment_actions pac, pay_payroll_actions ppa

1111: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
1112:
1113: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
1114: select MAX(pac.ASSIGNMENT_ACTION_ID) id
1115: from pay_assignment_actions pac, pay_payroll_actions ppa
1116: where ppa.action_type IN ('R','Q')
1117: and pac.payroll_action_id = ppa.payroll_action_id
1118: and pac.assignment_id= assg_id
1119: and ppa.payroll_id=pid

Line 1145: ,pay_assignment_actions act

1141: SELECT 1
1142: FROM pay_payroll_actions ppa
1143: ,pay_payroll_actions appa
1144: ,pay_payroll_actions appa2
1145: ,pay_assignment_actions act
1146: ,pay_assignment_actions act1
1147: ,pay_action_interlocks pai
1148: ,per_all_assignments_f as1
1149:

Line 1146: ,pay_assignment_actions act1

1142: FROM pay_payroll_actions ppa
1143: ,pay_payroll_actions appa
1144: ,pay_payroll_actions appa2
1145: ,pay_assignment_actions act
1146: ,pay_assignment_actions act1
1147: ,pay_action_interlocks pai
1148: ,per_all_assignments_f as1
1149:
1150: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 1188: FROM pay_assignment_actions paa,

1184: AND p_date_earned BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
1185:
1186: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1187: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1188: FROM pay_assignment_actions paa,
1189: pay_payroll_actions ppa
1190: WHERE ppa.payroll_action_id = paa.payroll_action_id
1191: and paa.assignment_id = p_assignment_id
1192: and ppa.action_type in ('R','Q','I','B','V')

Line 1934: FROM pay_assignment_actions

1930: BEGIN
1931:
1932: SELECT payroll_action_id, assignment_id
1933: INTO l_payroll_action_id,l_ass_id /* 9489806 */
1934: FROM pay_assignment_actions
1935: WHERE assignment_action_id=p_assignment_action_id;
1936: END;
1937:
1938: IF g_debug THEN