APPS.PA_TASK_PUB1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 3634: FROM pa_proj_structure_types ppst

3630:
3631: CURSOR cur_struc_type( x_structure_id NUMBER )
3632: IS
3633: SELECT 'Y'
3634: FROM pa_proj_structure_types ppst
3635: ,pa_structure_types pst
3636: WHERE ppst.proj_element_id = x_structure_id
3637: AND ppst.structure_type_id = pst.structure_type_id
3638: AND pst.structure_type_class_code = 'WORKPLAN';

Line 3643: FROM pa_proj_structure_types ppst

3639:
3640: CURSOR cur_struc_type2( c_structure_id NUMBER )
3641: IS
3642: SELECT 'Y'
3643: FROM pa_proj_structure_types ppst
3644: ,pa_structure_types pst
3645: WHERE ppst.proj_element_id = c_structure_id
3646: AND ppst.structure_type_id = pst.structure_type_id
3647: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 5694: FROM pa_proj_structure_types ppst

5690:
5691: CURSOR cur_struc_type( c_structure_id NUMBER )
5692: IS
5693: SELECT 'Y'
5694: FROM pa_proj_structure_types ppst
5695: ,pa_structure_types pst
5696: WHERE ppst.proj_element_id = c_structure_id
5697: AND ppst.structure_type_id = pst.structure_type_id
5698: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 6885: FROM pa_proj_structure_types ppst

6881:
6882: CURSOR cur_struc_type( c_structure_id NUMBER )
6883: IS
6884: SELECT 'Y'
6885: FROM pa_proj_structure_types ppst
6886: ,pa_structure_types pst
6887: WHERE ppst.proj_element_id = c_structure_id
6888: AND ppst.structure_type_id = pst.structure_type_id
6889: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 7446: FROM pa_proj_structure_types ppst

7442:
7443: CURSOR cur_struc_type( c_structure_id NUMBER )
7444: IS
7445: SELECT 'Y'
7446: FROM pa_proj_structure_types ppst
7447: ,pa_structure_types pst
7448: WHERE ppst.proj_element_id = c_structure_id
7449: AND ppst.structure_type_id = pst.structure_type_id
7450: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 9461: FROM pa_proj_structure_types ppst

9457:
9458:
9459: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
9460: SELECT 'Y'
9461: FROM pa_proj_structure_types ppst
9462: ,pa_structure_types pst
9463: WHERE ppst.proj_element_id = c_structure_id
9464: AND ppst.structure_type_id = pst.structure_type_id
9465: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 10946: FROM pa_proj_structure_types ppst

10942:
10943:
10944: CURSOR cur_struc_type( c_structure_id NUMBER ) IS
10945: SELECT 'Y'
10946: FROM pa_proj_structure_types ppst
10947: ,pa_structure_types pst
10948: WHERE ppst.proj_element_id = c_structure_id
10949: AND ppst.structure_type_id = pst.structure_type_id
10950: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 15714: FROM pa_proj_structure_types ppst

15710: /*4269830 : Performance Enhancements : Start */
15711: CURSOR cur_struc_type( c_structure_id NUMBER )
15712: IS
15713: SELECT 'Y'
15714: FROM pa_proj_structure_types ppst
15715: ,pa_structure_types pst
15716: WHERE ppst.proj_element_id = c_structure_id
15717: AND ppst.structure_type_id = pst.structure_type_id
15718: AND pst.structure_type_class_code = 'FINANCIAL' ;