APPS.GMD_OUTBOUND_APIS_PUB dependencies on HR_OPERATING_UNITS

Line 1973: ||' FROM hr_operating_units'

1969: THEN
1970: g_cust_vr_operating_unit := p_cust_vr_operating_unit;
1971: main_where_clause := main_where_clause||' AND mcvr.org_id = '
1972: ||' (SELECT organization_id'
1973: ||' FROM hr_operating_units'
1974: ||' WHERE name = :cust_vr_operating_unit)';
1975: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_operating_unit';
1976:
1977: cust_vr_where_clause := cust_vr_where_clause||' AND cvr.org_id = '

Line 1979: ||' FROM hr_operating_units'

1975: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_cust_vr_operating_unit';
1976:
1977: cust_vr_where_clause := cust_vr_where_clause||' AND cvr.org_id = '
1978: ||' (SELECT organization_id'
1979: ||' FROM hr_operating_units'
1980: ||' WHERE name = :cust_vr_operating_unit)';
1981: cust_vr_using_clause := cust_vr_using_clause||', gmd_outbound_apis_pub.g_cust_vr_operating_unit';
1982:
1983: END IF;

Line 2183: ||' FROM hr_operating_units'

2179: THEN
2180: g_supl_vr_operating_unit := p_supl_vr_operating_unit;
2181: main_where_clause := main_where_clause||' AND msvr.org_id = '
2182: ||' (SELECT organization_id'
2183: ||' FROM hr_operating_units'
2184: ||' WHERE name = :supl_vr_operating_unit)';
2185: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_operating_unit';
2186:
2187: supl_vr_where_clause := supl_vr_where_clause||' AND svr.org_id = '

Line 2189: ||' FROM hr_operating_units'

2185: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_operating_unit';
2186:
2187: supl_vr_where_clause := supl_vr_where_clause||' AND svr.org_id = '
2188: ||' (SELECT organization_id'
2189: ||' FROM hr_operating_units'
2190: ||' WHERE name = :supl_vr_operating_unit)';
2191: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_operating_unit';
2192:
2193: END IF;

Line 4553: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);

4549: END IF;
4550:
4551: IF g_samples_table(i).org_id is not NULL
4552: THEN
4553: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);
4554: select name into g_samples_table(i).org_name
4555: from hr_operating_units
4556: where organization_id = g_samples_table(i).org_id;
4557: END IF;

Line 4555: from hr_operating_units

4551: IF g_samples_table(i).org_id is not NULL
4552: THEN
4553: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);
4554: select name into g_samples_table(i).org_name
4555: from hr_operating_units
4556: where organization_id = g_samples_table(i).org_id;
4557: END IF;
4558:
4559: IF g_samples_table(i).supplier_id is not NULL