DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 957: from per_all_assignments_f

953: (select business_group_id
954: from per_all_people_f
955: where person_id in
956: (select person_id
957: from per_all_assignments_f
958: where assignment_id = cp_assignment_id));
959:
960: /****************************************************************
961: ** Below cursor added for bug 8643214 gets the business group id

Line 1950: per_all_assignments_f paf

1946: */
1947: select max(time_period_id)
1948: into l_time_period_id
1949: from per_time_periods ptp,
1950: per_all_assignments_f paf
1951: where ptp.payroll_id= paf.payroll_id
1952: and paf.assignment_id=p_id
1953: and p_effective_date between ptp.start_date and ptp.end_date;
1954: