DBA Data[Home] [Help]

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 4580: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);

4576: END IF;
4577:
4578: IF g_samples_table(i).org_id is not NULL
4579: THEN
4580: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);
4581: select name into g_samples_table(i).org_name
4582: from hr_operating_units
4583: where organization_id = g_samples_table(i).org_id;
4584: END IF;

Line 4582: from hr_operating_units

4578: IF g_samples_table(i).org_id is not NULL
4579: THEN
4580: --dbms_output.put_line('select from hr_operating_units using org_id of '|| g_samples_table(i).org_id);
4581: select name into g_samples_table(i).org_name
4582: from hr_operating_units
4583: where organization_id = g_samples_table(i).org_id;
4584: END IF;
4585:
4586: IF g_samples_table(i).supplier_id is not NULL