DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 508: FROM pqp_assignment_attributes_f

504: CURSOR c_get_work_pattern(c_assignment_id
505: IN per_all_assignments_f.assignment_id%TYPE,
506: c_effective_date IN DATE) IS
507: SELECT work_pattern
508: FROM pqp_assignment_attributes_f
509: WHERE assignment_id = c_assignment_id
510: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date;
511:
512: CURSOR c_get_start_end_date(c_assignment_id in NUMBER,