APPS.PAY_FI_TC_DP_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

60: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
61: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
62: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
63: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
65: l_datetrack_update_mode VARCHAR2(80);
66:
67: -- Variables to Read from File
68: l_ni VARCHAR2(80);

Line 144: FROM per_all_assignments_f PAA

140: ,p_ni per_all_people_f.national_identifier%TYPE
141: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
142: IS
143: SELECT PAA.ASSIGNMENT_ID
144: FROM per_all_assignments_f PAA
145: , per_all_people_f PAP
146: , hr_soft_coding_keyflex SCL
147: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
148: AND PAP.per_information_category ='FI'

Line 185: FROM per_all_assignments_f PAA

181: ,p_ni per_all_people_f.national_identifier%TYPE
182: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
183: IS
184: SELECT PAA.ASSIGNMENT_ID
185: FROM per_all_assignments_f PAA
186: , per_all_people_f PAP
187: , hr_soft_coding_keyflex SCL
188: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
189: AND PAP.per_information_category ='FI'

Line 221: (p_assignment_id per_all_assignments_f.assignment_id%TYPE

217:
218:
219:
220: CURSOR csr_get_element_details
221: (p_assignment_id per_all_assignments_f.assignment_id%TYPE
222: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE)
223: IS
224: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
225: from pay_element_entries_f pee

Line 228: , per_all_assignments_f paa

224: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
225: from pay_element_entries_f pee
226: , pay_element_types_f pet
227: , pay_element_links_f pel
228: , per_all_assignments_f paa
229: where pet.ELEMENT_NAME = p_element_name
230: and pet.legislation_code = 'FI'
231: and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
232: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID

Line 1120: FROM per_all_assignments_f

1116: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
1117:
1118: CURSOR csr_get_payroll_id IS
1119: SELECT payroll_id
1120: FROM per_all_assignments_f
1121: WHERE business_group_id = p_business_group_id
1122: AND assignment_id = p_assignment_id
1123: AND fnd_date.canonical_to_date(p_effective_date)
1124: BETWEEN effective_start_date AND effective_end_date ;