APPS.AMS_APPROVAL_DETAILS_PVT dependencies on AMS_CUSTOM_SETUPS_B

Line 144: FROM ams_custom_setups_b

140: l_usage VARCHAR2(30);
141: BEGIN
142: SELECT usage
143: INTO l_usage
144: FROM ams_custom_setups_b
145: WHERE custom_setup_id = p_custom_setup_id;
146:
147: IF l_usage = 'LITE' THEN
148: return FND_API.g_true;

Line 1731: where EXISTS (select 1 FROM ams_custom_setups_b

1727: AND category_id = id_in);
1728:
1729: cursor c_cust_setup_id_c_exists(id_in IN NUMBER) IS
1730: SELECT 1 from dual
1731: where EXISTS (select 1 FROM ams_custom_setups_b
1732: WHERE enabled_flag = 'Y'
1733: AND object_type IN ('RCAM','ECAM'));
1734:
1735: cursor c_cust_setup_id_exists(id_in IN NUMBER, p_lookup_code IN VARCHAR2) IS

Line 1737: where EXISTS (select 1 FROM ams_custom_setups_b

1733: AND object_type IN ('RCAM','ECAM'));
1734:
1735: cursor c_cust_setup_id_exists(id_in IN NUMBER, p_lookup_code IN VARCHAR2) IS
1736: SELECT 1 from dual
1737: where EXISTS (select 1 FROM ams_custom_setups_b
1738: WHERE enabled_flag = 'Y'
1739: AND object_type = p_lookup_code);
1740: BEGIN
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;