APPS.PA_TASK_PUB1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 3565: FROM pa_proj_structure_types ppst

3561:
3562: CURSOR cur_struc_type( x_structure_id NUMBER )
3563: IS
3564: SELECT 'Y'
3565: FROM pa_proj_structure_types ppst
3566: ,pa_structure_types pst
3567: WHERE ppst.proj_element_id = x_structure_id
3568: AND ppst.structure_type_id = pst.structure_type_id
3569: AND pst.structure_type_class_code = 'WORKPLAN';

Line 3574: FROM pa_proj_structure_types ppst

3570:
3571: CURSOR cur_struc_type2( c_structure_id NUMBER )
3572: IS
3573: SELECT 'Y'
3574: FROM pa_proj_structure_types ppst
3575: ,pa_structure_types pst
3576: WHERE ppst.proj_element_id = c_structure_id
3577: AND ppst.structure_type_id = pst.structure_type_id
3578: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 5419: FROM pa_proj_structure_types ppst

5415:
5416: CURSOR cur_struc_type( c_structure_id NUMBER )
5417: IS
5418: SELECT 'Y'
5419: FROM pa_proj_structure_types ppst
5420: ,pa_structure_types pst
5421: WHERE ppst.proj_element_id = c_structure_id
5422: AND ppst.structure_type_id = pst.structure_type_id
5423: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 6602: FROM pa_proj_structure_types ppst

6598:
6599: CURSOR cur_struc_type( c_structure_id NUMBER )
6600: IS
6601: SELECT 'Y'
6602: FROM pa_proj_structure_types ppst
6603: ,pa_structure_types pst
6604: WHERE ppst.proj_element_id = c_structure_id
6605: AND ppst.structure_type_id = pst.structure_type_id
6606: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 7149: FROM pa_proj_structure_types ppst

7145:
7146: CURSOR cur_struc_type( c_structure_id NUMBER )
7147: IS
7148: SELECT 'Y'
7149: FROM pa_proj_structure_types ppst
7150: ,pa_structure_types pst
7151: WHERE ppst.proj_element_id = c_structure_id
7152: AND ppst.structure_type_id = pst.structure_type_id
7153: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 9098: FROM pa_proj_structure_types ppst

9094:
9095:
9096: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
9097: SELECT 'Y'
9098: FROM pa_proj_structure_types ppst
9099: ,pa_structure_types pst
9100: WHERE ppst.proj_element_id = c_structure_id
9101: AND ppst.structure_type_id = pst.structure_type_id
9102: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 10566: FROM pa_proj_structure_types ppst

10562:
10563:
10564: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
10565: SELECT 'Y'
10566: FROM pa_proj_structure_types ppst
10567: ,pa_structure_types pst
10568: WHERE ppst.proj_element_id = c_structure_id
10569: AND ppst.structure_type_id = pst.structure_type_id
10570: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 15181: FROM pa_proj_structure_types ppst

15177: /*4269830 : Performance Enhancements : Start */
15178: CURSOR cur_struc_type( c_structure_id NUMBER )
15179: IS
15180: SELECT 'Y'
15181: FROM pa_proj_structure_types ppst
15182: ,pa_structure_types pst
15183: WHERE ppst.proj_element_id = c_structure_id
15184: AND ppst.structure_type_id = pst.structure_type_id
15185: AND pst.structure_type_class_code = 'FINANCIAL' ;