APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ALL_ASSIGNMENTS_F

Line 713: ,per_all_assignments_f as1

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
716: AND l_canonical_end_date
717: AND as1.person_id BETWEEN p_start_person

Line 873: per_all_assignments_f assign,

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
877: AND assign.person_id = pap.person_id

Line 1012: FROM per_all_assignments_f asg1

1008:
1009: /* Cursor to retrieve Element - Employee ATP*/
1010: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1011: SELECT eev1.screen_entry_value screen_entry_value
1012: FROM per_all_assignments_f asg1
1013: ,per_all_people_f per
1014: ,pay_element_links_f el
1015: ,pay_element_types_f et
1016: ,pay_input_values_f iv1

Line 1047: FROM per_all_assignments_f asg1

1043:
1044: /* Cursor to retrieve Element - Tax Card*/
1045: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1046: SELECT ee.effective_start_date, eev1.screen_entry_value
1047: FROM per_all_assignments_f asg1
1048: ,per_all_people_f per
1049: ,pay_element_links_f el
1050: ,pay_element_types_f et
1051: ,pay_input_values_f iv1

Line 1086: FROM per_all_assignments_f paa

1082: ,p_start_date DATE
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

Line 1148: ,per_all_assignments_f as1

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
1151: AND appa.effective_date BETWEEN l_canonical_start_date
1152: AND l_canonical_end_date