DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on PER_PEOPLE_F

Line 28: per_assignments_f paf,per_people_f ppf

24: CURSOR assign_num_cur IS
25: SELECT paf.assignment_number,
26: ppf.employee_number
27: FROM
28: per_assignments_f paf,per_people_f ppf
29: WHERE paf.assignment_id =p_assignment_id
30: AND paf.person_id =ppf.person_id
31: and paf.assignment_type = 'E'
32: AND p_payroll_start_date between paf.effective_start_date and paf.effective_end_date

Line 4048: FROM per_people_f

4044:
4045: /* Following cursor is added for bug 2514611 */
4046: CURSOR employee_name_cur IS
4047: SELECT full_name
4048: FROM per_people_f
4049: WHERE person_id =p_person_id;
4050:
4051: /*
4052: CURSOR global_susp_account_cur(P_PAYROLL_START_DATE IN DATE) IS