DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 466: FROM pqp_assignment_attributes_f

462: CURSOR c_get_work_pattern(c_assignment_id
463: IN per_all_assignments_f.assignment_id%TYPE,
464: c_effective_date IN DATE) IS
465: SELECT work_pattern
466: FROM pqp_assignment_attributes_f
467: WHERE assignment_id = c_assignment_id
468: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date;
469:
470: CURSOR c_get_start_end_date(c_assignment_id in NUMBER,