DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 259: FROM pa_proj_structure_types ppst

255:
256: CURSOR cur_struc_type
257: IS
258: SELECT 'Y'
259: FROM pa_proj_structure_types ppst
260: ,pa_structure_types pst
261: WHERE ppst.proj_element_id = p_structure_id
262: AND ppst.structure_type_id = pst.structure_type_id
263: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 1664: FROM pa_proj_structure_types ppst

1660:
1661: CURSOR cur_struc_type( c_structure_id NUMBER )
1662: IS
1663: SELECT 'Y'
1664: FROM pa_proj_structure_types ppst
1665: ,pa_structure_types pst
1666: WHERE ppst.proj_element_id = c_structure_id
1667: AND ppst.structure_type_id = pst.structure_type_id
1668: AND pst.structure_type_class_code IN( 'FINANCIAL' );