APPS.EGO_CHANGE_PEOPLE_IMPORT_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 335: || 'FROM ENG_ENGINEERING_CHANGES OUT_ENG_CHANGES ';

331: --EXECUTE IMMEDIATE 'TRUNCATE TABLE ENG_LOGIN_ACCESS_CHANGES';
332: DELETE ENG_LOGIN_ACCESS_CHANGES;
333:
334: l_select_sql := 'SELECT OUT_ENG_CHANGES.CHANGE_NOTICE, OUT_ENG_CHANGES.CHANGE_MGMT_TYPE_CODE, OUT_ENG_CHANGES.ORGANIZATION_ID '
335: || 'FROM ENG_ENGINEERING_CHANGES OUT_ENG_CHANGES ';
336:
337: EGO_DATA_SECURITY.get_security_predicate(
338: p_api_version => 1.0,
339: p_function => 'ENG_EDIT_CHANGE', -- fnd_form_function.function_name which specify that user has access

Line 1909: FROM eng_engineering_changes eec

1905:
1906: UPDATE eng_change_people_intf ecpi
1907: SET ecpi.change_id =
1908: ( SELECT change_id
1909: FROM eng_engineering_changes eec
1910: WHERE ecpi.change_notice = eec.change_notice
1911: AND ecpi.organization_id = eec.organization_id
1912: AND ecpi.change_mgmt_type_code = eec.change_mgmt_type_code
1913: )

Line 1919: FROM eng_engineering_changes eec

1915: AND ecpi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER
1916: AND ecpi.process_status = G_PS_IN_PROCESS
1917: AND ecpi.change_id IS NULL
1918: AND EXISTS ( SELECT change_id
1919: FROM eng_engineering_changes eec
1920: WHERE ecpi.change_notice = eec.change_notice
1921: AND ecpi.organization_id = eec.organization_id
1922: AND ecpi.change_mgmt_type_code = eec.change_mgmt_type_code
1923: );