DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PA_NON_LABOR_RESOURCES

Line 241: FROM pa_non_labor_resources

237: IF p_resource_type_code = 'NON_LABOR_RESOURCE' THEN
238: BEGIN
239: SELECT non_labor_resource
240: INTO l_element_name
241: FROM pa_non_labor_resources
242: WHERE NON_LABOR_RESOURCE_ID = p_resource_source_id;
243: EXCEPTION
244: WHEN OTHERS THEN
245: l_element_name := NULL;

Line 744: pa_non_labor_resources c,

740: FND_GLOBAL.LOGIN_ID
741: FROM
742: pa_rbs_element_names_b a,
743: pa_rbs_elem_in_temp b,
744: pa_non_labor_resources c,
745: Fnd_Languages L
746: WHERE a.resource_source_id = b.resource_source_id
747: AND a.resource_type_id = p_resource_type_id
748: AND b.resource_type_id = p_resource_type_id

Line 2171: FROM pa_non_labor_resources r,

2167: fnd_global.user_id,
2168: sysdate,
2169: fnd_global.user_id,
2170: fnd_global.login_id
2171: FROM pa_non_labor_resources r,
2172: pa_rbs_element_names_b a,
2173: Fnd_Languages L
2174: WHERE a.resource_source_id =
2175: r.non_labor_resource_id