[Home] [Help]
188:
189: CURSOR check_prog_flag
190: IS
191: SELECT sys_program_flag
192: FROM pa_projects_all
193: WHERE project_id = p_project_id
194: ;
195:
196: l_program_flag VARCHAR2(1) := 'N';
1507: ,pa_proj_elem_ver_schedule ppvsch
1508: ,per_all_people_f papf
1509: ,pa_project_statuses pps2
1510: ,hr_all_organization_units_tl hou
1511: ,pa_projects_all ppa
1512: ,pa_proj_structure_types ppst
1513: ,pa_structure_types pst
1514: ,pa_work_types_tl pwt
1515: ,pa_task_types tt
2084: ,pa_proj_elem_ver_schedule ppvsch
2085: ,per_all_people_f papf
2086: ,pa_project_statuses pps2
2087: ,hr_all_organization_units_tl hou
2088: ,pa_projects_all ppa
2089: ,pa_proj_structure_types ppst
2090: ,pa_structure_types pst
2091: ,pa_work_types_tl pwt
2092: ,pa_task_types tt
2906: ,pa_proj_elem_ver_schedule ppvsch
2907: ,per_all_people_f papf
2908: ,pa_project_statuses pps2
2909: ,hr_all_organization_units_tl hou
2910: ,pa_projects_all ppa
2911: ,pa_proj_structure_types ppst
2912: ,pa_structure_types pst
2913: ,pa_work_types_tl pwt
2914: ,pa_task_types tt
3486: ,pa_proj_elem_ver_schedule ppvsch
3487: ,per_all_people_f papf
3488: ,pa_project_statuses pps2
3489: ,hr_all_organization_units_tl hou
3490: ,pa_projects_all ppa
3491: ,pa_proj_structure_types ppst
3492: ,pa_structure_types pst
3493: ,pa_work_types_tl pwt
3494: ,pa_task_types tt
4356: ,pa_proj_elem_ver_schedule ppvsch
4357: ,per_all_people_f papf
4358: ,pa_project_statuses pps2
4359: ,hr_all_organization_units_tl hou
4360: ,pa_projects_all ppa
4361: ,pa_proj_structure_types ppst
4362: ,pa_structure_types pst
4363: ,pa_work_types_tl pwt
4364: ,pa_task_types tt
4931: ,pa_proj_elem_ver_schedule ppvsch
4932: ,per_all_people_f papf
4933: ,pa_project_statuses pps2
4934: ,hr_all_organization_units_tl hou
4935: ,pa_projects_all ppa
4936: ,pa_proj_structure_types ppst
4937: ,pa_structure_types pst
4938: ,pa_work_types_tl pwt
4939: ,pa_task_types tt
5962: ,pa_proj_elem_ver_schedule ppvsch
5963: ,per_all_people_f papf
5964: ,pa_project_statuses pps2
5965: ,hr_all_organization_units_tl hou
5966: ,pa_projects_all ppa
5967: ,pa_proj_structure_types ppst
5968: ,pa_structure_types pst
5969: ,pa_work_types_tl pwt
5970: ,pa_task_types tt
6788: ,pa_proj_elem_ver_schedule ppvsch
6789: ,per_all_people_f papf
6790: ,pa_project_statuses pps2
6791: ,hr_all_organization_units_tl hou
6792: ,pa_projects_all ppa
6793: ,pa_proj_structure_types ppst
6794: ,pa_structure_types pst
6795: ,pa_work_types_tl pwt
6796: ,pa_task_types tt
7615: ,pa_proj_elem_ver_schedule ppvsch
7616: ,per_all_people_f papf
7617: ,pa_project_statuses pps2
7618: ,hr_all_organization_units_tl hou
7619: ,pa_projects_all ppa
7620: ,pa_proj_structure_types ppst
7621: ,pa_structure_types pst
7622: ,pa_work_types_tl pwt
7623: ,pa_task_types tt
8557: FROM
8558: pa_proj_elem_ver_structure ppvs
8559: ,pa_proj_elem_ver_schedule ppvsch
8560: ,per_all_people_f papf
8561: ,pa_projects_all ppa
8562: ,pa_page_layouts ppl
8563: ,pa_project_statuses pps
8564: ,pa_proj_element_versions ppv2
8565: ,pa_proj_elements ppe
9048: FROM
9049: pa_proj_elem_ver_structure ppvs
9050: ,pa_proj_elem_ver_schedule ppvsch
9051: ,per_all_people_f papf
9052: ,pa_projects_all ppa
9053: ,pa_page_layouts ppl
9054: ,pa_project_statuses pps
9055: ,pa_proj_element_versions ppv2
9056: ,pa_proj_elements ppe
9556: FROM
9557: pa_proj_elem_ver_structure ppvs
9558: ,pa_proj_elem_ver_schedule ppvsch
9559: ,per_all_people_f papf
9560: ,pa_projects_all ppa
9561: ,pa_page_layouts ppl
9562: ,pa_project_statuses pps
9563: ,pa_proj_element_versions ppv2
9564: ,pa_proj_elements ppe
10386: ,pa_proj_elem_ver_schedule ppvsch
10387: ,per_all_people_f papf
10388: ,pa_project_statuses pps2
10389: ,hr_all_organization_units_tl hou
10390: ,pa_projects_all ppa
10391: ,pa_proj_structure_types ppst
10392: ,pa_structure_types pst
10393: ,pa_work_types_tl pwt
10394: ,pa_task_types tt
11146: ,pa_proj_elem_ver_schedule ppvsch
11147: ,per_all_people_f papf
11148: ,pa_project_statuses pps2
11149: ,hr_all_organization_units_tl hou
11150: ,pa_projects_all ppa
11151: ,pa_proj_structure_types ppst
11152: ,pa_structure_types pst
11153: ,pa_work_types_tl pwt
11154: ,pa_task_types tt
12097: ,per_all_people_f papf
12098: ,pa_project_statuses pps2
12099: ,pa_lookups fl3
12100: ,hr_all_organization_units_tl hou
12101: ,pa_projects_all ppa
12102: ,pa_proj_element_versions ppv2
12103: ,pa_proj_structure_types ppst
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12925: ,per_all_people_f papf
12926: ,pa_project_statuses pps2
12927: ,pa_lookups fl3
12928: ,hr_all_organization_units_tl hou
12929: ,pa_projects_all ppa
12930: ,pa_proj_element_versions ppv2
12931: ,pa_proj_structure_types ppst
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
13754: ,per_all_people_f papf
13755: ,pa_project_statuses pps2
13756: ,pa_lookups fl3
13757: ,hr_all_organization_units_tl hou
13758: ,pa_projects_all ppa
13759: ,pa_proj_element_versions ppv2
13760: ,pa_proj_structure_types ppst
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
14679: ,per_all_people_f papf
14680: ,pa_project_statuses pps2
14681: ,pa_lookups fl3
14682: ,hr_all_organization_units_tl hou
14683: ,pa_projects_all ppa
14684: ,pa_proj_element_versions ppv2
14685: ,pa_proj_structure_types ppst
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
15476: ,per_all_people_f papf
15477: ,pa_project_statuses pps2
15478: ,pa_lookups fl3
15479: ,hr_all_organization_units_tl hou
15480: ,pa_projects_all ppa
15481: ,pa_proj_element_versions ppv2
15482: ,pa_proj_structure_types ppst
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
16274: ,per_all_people_f papf
16275: ,pa_project_statuses pps2
16276: ,pa_lookups fl3
16277: ,hr_all_organization_units_tl hou
16278: ,pa_projects_all ppa
16279: ,pa_proj_element_versions ppv2
16280: ,pa_proj_structure_types ppst
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1