DBA Data[Home] [Help]

APPS.PA_UTILS4 dependencies on PA_WORK_TYPES_B

Line 622: FROM pa_work_types_b

618:
619: If p_work_type_id is NOT NULL then
620: SELECT tp_amt_type_code
621: INTO l_tp_amt_code
622: FROM pa_work_types_b
623: WHERE work_type_id = p_work_type_id
624: AND trunc(sysdate) between start_date_active
625: and nvl(end_date_active,sysdate);
626: End if;

Line 729: FROM pa_work_types_b -- bug 4668816 changed from pa_work_types_v to pa_work_types_b

725: RETURN varchar2 IS
726:
727: CURSOR cur_billwork IS
728: SELECT BILLABLE_CAPITALIZABLE_FLAG
729: FROM pa_work_types_b -- bug 4668816 changed from pa_work_types_v to pa_work_types_b
730: WHERE work_type_id = p_work_type_id
731: AND trunc(sysdate) between start_date_active and
732: nvl(end_date_active,sysdate);
733: