APPS.PAY_NO_TC_DP_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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

Line 135: FROM per_all_assignments_f PAA

131: ,p_ni per_all_people_f.national_identifier%TYPE
132: )
133: IS
134: SELECT PAA.ASSIGNMENT_ID
135: FROM per_all_assignments_f PAA
136: , per_all_people_f PAP
137: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
138: AND PAP.per_information_category ='NO'
139: AND PAP.NATIONAL_IDENTIFIER = p_ni

Line 147: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE )

143: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
144:
145:
146:
147: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE )
148: IS
149: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
150: from pay_element_entries_f pee
151: , pay_element_types_f pet

Line 153: , per_all_assignments_f paa

149: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
150: from pay_element_entries_f pee
151: , pay_element_types_f pet
152: , pay_element_links_f pel
153: , per_all_assignments_f paa
154: where pet.ELEMENT_NAME = 'Tax Card'
155: and pet.legislation_code = 'NO'
156: and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
157: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID

Line 998: FROM per_all_assignments_f

994: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
995:
996: CURSOR csr_get_payroll_id IS
997: SELECT payroll_id
998: FROM per_all_assignments_f
999: WHERE business_group_id = p_business_group_id
1000: AND assignment_id = p_assignment_id
1001: AND fnd_date.canonical_to_date(p_effective_date)
1002: BETWEEN effective_start_date AND effective_end_date ;