APPS.PA_ADJUSTMENTS dependencies on PA_WORK_TYPES_B

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

2333:
2334: IF (l_proj_type_class_code = 'INDIRECT') then
2335: SELECT nvl(BILLABLE_CAPITALIZABLE_FLAG,'N')
2336: INTO l_billable_cap_flag
2337: FROM pa_work_types_b -- bug 4668802 changed from pa_work_types_v to pa_work_types_b
2338: WHERE work_type_id = p_work_type_id
2339: AND trunc(sysdate) between start_date_active and
2340: nvl(end_date_active,sysdate);
2341:

Line 6416: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;

6412: if v_allow_adjustments = 'N'
6413: and x_adj_action in ( 'CHANGE WORK TYPE ATTRIBUTE')
6414: and v_project_type_class_code = 'INDIRECT' then
6415: declare
6416: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;
6417: begin
6418: select billable_capitalizable_flag
6419: into l_billable_capitalizable_flag
6420: from pa_work_types_b

Line 6420: from pa_work_types_b

6416: l_billable_capitalizable_flag pa_work_types_b.billable_capitalizable_flag%TYPE;
6417: begin
6418: select billable_capitalizable_flag
6419: into l_billable_capitalizable_flag
6420: from pa_work_types_b
6421: where work_type_id = p_dest_work_type_id;
6422: if l_billable_capitalizable_flag = 'Y' then
6423: v_allow_adjustments := 'PA_ADJ_WT_IND_PRJ_NOT_ALLOW';
6424: end if;