APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_INTEGRATION_SETTINGS

Line 714: pa_proj_structure_types PPST, pa_integration_settings pis

710: --Changed this query for fetching correct tasks in case of split structures.
711: select a.element_version_id , a.proj_element_id , c.element_number bulk collect
712: into l_elem_ver_id_tbl,l_task_id_tbl , l_task_num_tbl
713: from pa_proj_element_versions a , pa_proj_elem_ver_structure s, pa_proj_elements c, pa_proj_element_versions d,
714: pa_proj_structure_types PPST, pa_integration_settings pis
715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id
718: and a.object_type = 'PA_TASKS'

Line 1752: from pa_integration_settings

1748:
1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',
1750: 'FINANCIAL', structure_type), receive_task , structure_type
1751: into l_struct_type , l_receive_task , l_setup_struct_type
1752: from pa_integration_settings
1753: where project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID
1754: and enable_integration = 'Y';
1755:
1756: else

Line 1761: from pa_integration_settings

1757:
1758: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_create_from_project_id ), 'N',
1759: 'FINANCIAL', structure_type) , receive_task, structure_type
1760: into l_struct_type , l_receive_task , l_setup_struct_type
1761: from pa_integration_settings
1762: where project_id = l_create_from_project_id
1763: and enable_integration = 'Y';
1764:
1765: end if ;

Line 2870: FROM PA_INTEGRATION_SETTINGS PaProjectIntegrationSettingsEO

2866: PaProjectIntegrationSettingsEO.SYNCHRONIZE_MARK,
2867: PaProjectIntegrationSettingsEO.LAST_SYNCHRONIZATION_DATE,
2868: PaProjectIntegrationSettingsEO.SYNCHRONIZATION_STAGE,
2869: PaProjectIntegrationSettingsEO.CREATE_PLANNING_RESOURCE
2870: FROM PA_INTEGRATION_SETTINGS PaProjectIntegrationSettingsEO
2871: WHERE PaProjectIntegrationSettingsEO.PROJECT_ID = CP_PROJECT_ID;
2872:
2873: BEGIN
2874:

Line 2877: INSERT INTO PA_INTEGRATION_SETTINGS (

2873: BEGIN
2874:
2875: FOR C_SOURCE_RECORD IN C_SOURCE_RECORDS(P_ORIG_PROJECT_ID) LOOP
2876: BEGIN
2877: INSERT INTO PA_INTEGRATION_SETTINGS (
2878: PROJECT_ID,
2879: ENABLE_INTEGRATION,
2880: STRUCTURE_TYPE,
2881: SEND_ACTUAL_COST_TYPE,

Line 3175: from pa_integration_settings i1, pa_projects_all p1

3171: l_fin_plan_type_id := null;
3172: l_budget_type := null;
3173: select i1.fin_plan_type_id , i1.budget_type, p1.start_date , p1.completion_date
3174: into l_fin_plan_type_id , l_budget_type, l_start_date , l_end_date
3175: from pa_integration_settings i1, pa_projects_all p1
3176: where i1.project_id = l_budget_in_obj.project_id
3177: and i1.project_id = p1.project_id
3178: and i1.enable_integration = 'Y';
3179: