APPS.PA_TASK_PUB1 dependencies on PA_STRUCTURE_TYPES

Line 3566: ,pa_structure_types pst

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';
3570:

Line 3575: ,pa_structure_types pst

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' );
3579:

Line 5420: ,pa_structure_types pst

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' );
5424:

Line 6603: ,pa_structure_types pst

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' );
6607:

Line 7150: ,pa_structure_types pst

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' );
7154:

Line 9099: ,pa_structure_types pst

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' );
9103:

Line 10567: ,pa_structure_types pst

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' );
10571:

Line 15182: ,pa_structure_types pst

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' ;
15186: