APPS.PA_RESOURCE_LIST_PKG dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 553: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

549: l_count NUMBER;
550: x_err_code NUMBER;
551: x_err_stage VARCHAR2(100);
552: l_resource_id pa_resource_list_members.resource_id%TYPE;
553: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
554: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%TYPE;
555:
556: Begin
557:

Line 563: FROM PA_RESOURCE_LISTS_ALL_BG

559: condition, we are checking that there is non zero value for group_resource_type_id for resource list id in table */
560:
561: SELECT Group_Resource_Type_ID
562: INTO l_group_resource_type_id
563: FROM PA_RESOURCE_LISTS_ALL_BG
564: WHERE resource_list_id = x_resource_list_id;
565:
566: If SQL%NOTFOUND Then
567: Raise NO_DATA_FOUND;