APPS.PA_ADJUSTMENTS dependencies on PA_WORK_TYPES_B

Line 2393: FROM pa_work_types_b -- bug 4668802 changed from pa_work_types_v to pa_work_types_b

2389:
2390: IF (l_proj_type_class_code = 'INDIRECT') then
2391: SELECT nvl(BILLABLE_CAPITALIZABLE_FLAG,'N')
2392: INTO l_billable_cap_flag
2393: FROM pa_work_types_b -- bug 4668802 changed from pa_work_types_v to pa_work_types_b
2394: WHERE work_type_id = p_work_type_id
2395: AND trunc(sysdate) between start_date_active and
2396: nvl(end_date_active,sysdate);
2397:

Line 6580: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;

6576: if v_allow_adjustments = 'N'
6577: and x_adj_action in ( 'CHANGE WORK TYPE ATTRIBUTE')
6578: and v_project_type_class_code = 'INDIRECT' then
6579: declare
6580: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;
6581: begin
6582: select billable_capitalizable_flag
6583: into l_billable_capitalizable_flag
6584: from pa_work_types_b

Line 6584: from pa_work_types_b

6580: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;
6581: begin
6582: select billable_capitalizable_flag
6583: into l_billable_capitalizable_flag
6584: from pa_work_types_b
6585: where work_type_id = p_dest_work_type_id;
6586: if l_billable_capitalizable_flag = 'Y' then
6587: v_allow_adjustments := 'PA_ADJ_WT_IND_PRJ_NOT_ALLOW';
6588: end if;