APPS.PA_GET_RESOURCE dependencies on PA_RESOURCE_LISTS

Line 20: pa_resource_lists

16: CURSOR c_resource_lists_csr IS
17: SELECT
18: group_resource_type_id
19: FROM
20: pa_resource_lists
21: WHERE resource_list_id = p_resource_list_id;
22:
23: CURSOR c_resource_types_csr IS
24: SELECT

Line 68: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';

64: BEGIN
65: l_old_stack := p_err_stack;
66: p_err_code := 0;
67: p_err_stack := p_err_stack ||'->PA_GET_RESOURCE.Get_resource_group';
68: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
69:
70: --- Get the group_resource_type_id of the resource_list
71: --- from pa_resource_lists using
72: --- x_resource_list_id.

Line 71: --- from pa_resource_lists using

67: p_err_stack := p_err_stack ||'->PA_GET_RESOURCE.Get_resource_group';
68: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
69:
70: --- Get the group_resource_type_id of the resource_list
71: --- from pa_resource_lists using
72: --- x_resource_list_id.
73:
74: OPEN c_resource_lists_csr;
75: FETCH c_resource_lists_csr INTO l_resource_type_id;

Line 878: pa_resource_lists rl,

874: rlm.resource_list_member_id,
875: rlm.resource_id,
876: rlm.track_as_labor_flag
877: FROM
878: pa_resource_lists rl,
879: pa_resource_list_members rlm
880: WHERE rl.uncategorized_flag = 'Y'
881: AND rlm.resource_class_code = 'FINANCIAL_ELEMENTS' -- shelly
882: AND rlm.resource_class_flag = 'Y' --shelly