DBA Data[Home] [Help]

APPS.PSP_PEE_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 501: FROM per_all_assignments_f paaf,

497: l_assignment_id NUMBER;
498: --
499: CURSOR assignment_id_csr IS
500: SELECT assignment_id
501: FROM per_all_assignments_f paaf,
502: pay_all_payrolls_f papf
503: WHERE paaf.payroll_id = papf.payroll_id
504: AND paaf.assignment_id = p_assignment_id
505: AND paaf.person_id = p_person_id

Line 1004: FROM per_all_assignments_f paaf,

1000: AND p_distribution_date between effective_start_date and effective_end_date;
1001:
1002: CURSOR assignment_csr(p_assignment_id IN NUMBER, p_person_id IN NUMBER, p_business_group_id IN NUMBER, p_distribution_date IN DATE) IS
1003: SELECT assignment_id
1004: FROM per_all_assignments_f paaf,
1005: pay_all_payrolls_f papf
1006: WHERE paaf.payroll_id = papf.payroll_id
1007: AND paaf.assignment_id = p_assignment_id
1008: AND paaf.person_id = p_person_id