APPS.PAY_SE_TAX_CARD dependencies on PER_ALL_ASSIGNMENTS_F

Line 78: L_ASSIGNMENT_ID per_all_assignments_f.assignment_id%TYPE;

74: -- Variables to Read from File
75: l_pin VARCHAR2(80);
76: l_employer_org_no VARCHAR2(80);
77:
78: L_ASSIGNMENT_ID per_all_assignments_f.assignment_id%TYPE;
79: L_ELEMENT_ENTRY_ID pay_element_entries_f.element_entry_id%TYPE;
80: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
81: L_ELEMENT_NAME pay_element_types_f.element_name%TYPE;
82:

Line 141: FROM per_all_assignments_f PAA

137: ,p_pin per_all_people_f.national_identifier%TYPE
138: )
139: IS
140: SELECT PAA.ASSIGNMENT_ID
141: FROM per_all_assignments_f PAA
142: , per_all_people_f PAP
143: , hr_soft_coding_keyflex SCL
144: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
145: AND PAP.per_information_category ='SE'

Line 179: p_assignment_id per_all_assignments_f.assignment_id%TYPE

175: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date))
176: ) ;
177:
178: CURSOR csr_get_element_details(
179: p_assignment_id per_all_assignments_f.assignment_id%TYPE
180: )
181: IS
182: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
183: from pay_element_entries_f pee

Line 186: , per_all_assignments_f paa

182: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
183: from pay_element_entries_f pee
184: , pay_element_types_f pet
185: , pay_element_links_f pel
186: , per_all_assignments_f paa
187: where pet.ELEMENT_NAME = 'Tax Card'
188: and pet.legislation_code = 'SE'
189: and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
190: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID

Line 951: FROM per_all_assignments_f

947: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
948:
949: CURSOR csr_get_payroll_id IS
950: SELECT payroll_id
951: FROM per_all_assignments_f
952: WHERE business_group_id = p_business_group_id
953: AND assignment_id = p_assignment_id
954: AND fnd_date.canonical_to_date(p_effective_date)
955: BETWEEN effective_start_date AND effective_end_date ;