APPS.PAY_IP_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 216: per_all_assignments_f asg

212: --
213: select
214: min(asg.effective_start_date) start_date
215: from
216: per_all_assignments_f asg
217: ,per_time_periods ptp
218: where
219: asg.assignment_id = p_assignment_id
220: and ptp.payroll_id = asg.payroll_id

Line 233: per_all_assignments_f asg

229: --
230: select
231: min(ptp.start_date) start_date
232: from
233: per_all_assignments_f asg
234: ,per_time_periods ptp
235: where
236: asg.assignment_id = p_assignment_id
237: and ptp.payroll_id = asg.payroll_id

Line 348: FROM per_all_assignments_f ass

344: (p_assignment_id NUMBER
345: ,p_upload_date DATE
346: ) IS
347: SELECT ptp.start_date
348: FROM per_all_assignments_f ass
349: ,per_time_periods ptp
350: WHERE ass.assignment_id = p_assignment_id
351: AND ass.effective_start_date <= p_upload_date
352: AND ass.effective_end_date >= p_upload_date

Line 389: l_business_group_id PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;

385: and pee.original_entry_id is null)
386: or (pee.original_entry_id = p_original_entry_id));
387:
388: l_expiry_date DATE;
389: l_business_group_id PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID%TYPE;
390: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;
391: l_itd_start_date date;
392: l_oe_start_date date;
393: BEGIN