APPS.PAY_ELEMENT_ENTRY_API dependencies on PER_ASSIGNMENTS_F

Line 177: l_business_group_id per_assignments_f.business_group_id%TYPE;

173: --
174: l_indirect_only_flag pay_element_types_f.indirect_only_flag%TYPE;
175: -- Bugfix 10271804
176: -- p_business_group_id is obsolete so fetch business group of assignment
177: l_business_group_id per_assignments_f.business_group_id%TYPE;
178: --
179: CURSOR c_output_variables IS
180: SELECT ee.object_version_number
181: FROM pay_element_entries_f ee

Line 189: per_assignments_f pas

185: and ee.effective_end_date;
186: CURSOR c_assignment_details IS
187: SELECT ptp.status
188: FROM per_time_periods ptp,
189: per_assignments_f pas
190: WHERE pas.assignment_id = p_assignment_id
191: AND pas.payroll_id = ptp.payroll_id
192: AND l_effective_date BETWEEN ptp.start_date
193: AND ptp.end_date

Line 198: FROM per_assignments_f pas

194: AND l_effective_date BETWEEN pas.effective_start_date
195: AND pas.effective_end_date;
196: CURSOR c_assignment_bg IS
197: SELECT business_group_id
198: FROM per_assignments_f pas
199: WHERE pas.assignment_id = p_assignment_id;
200:
201: CURSOR c_entry_exists IS
202: SELECT /*+ LEADING(ee)