DBA Data[Home] [Help]

APPS.PQP_AAT_API dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 569: FROM pqp_assignment_attributes_f

565: --are updated but not the contract details or workpattern or start day.
566: CURSOR c_contract_workpattern IS
567: SELECT effective_start_date, effective_end_date effective_end_date,
568: contract_type, work_pattern, start_day, object_version_number
569: FROM pqp_assignment_attributes_f
570: WHERE assignment_id = p_assignment_id
571: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
572:
573: l_legislation_code pay_user_rows_f.legislation_code%TYPE;

Line 617: l_start_day pqp_assignment_attributes_f.start_day%TYPE;

613:
614:
615: l_contract_workpattern c_contract_workpattern%ROWTYPE;
616:
617: l_start_day pqp_assignment_attributes_f.start_day%TYPE;
618:
619: l_wp_days NUMBER:=0;
620: l_no_days NUMBER:=0;
621: l_days_tobe_added NUMBER:=0;