APPS.GMS_SWEEPER dependencies on PA_RESOURCE_LIST_MEMBERS

Line 741: pa_resource_list_members prm

737: gei.rowid
738: from gms_event_intersect gei,
739: pa_expenditure_items_all item,
740: gms_award_distributions gad ,
741: pa_resource_list_members prm
742: where gei.expenditure_item_id = gad.expenditure_item_id
743: and gei.adl_line_num = gad.adl_line_num
744: and gei.event_type = 'REVENUE'
745: -- and gei.revenue_accumulated = 'N'

Line 774: pa_resource_list_members prm

770: from gms_burden_components gbc,
771: pa_expenditure_items_all item ,
772: pa_expenditures_all pea,
773: gms_award_distributions gad ,
774: pa_resource_list_members prm
775: where gbc.expenditure_item_id = gad.expenditure_item_id
776: and gbc.adl_line_num = gad.adl_line_num
777: and gbc.event_type = 'REVENUE'
778: -- and gbc.revenue_accumulated = 'N'

Line 806: -- pa_resource_list_members prm

802: -- from gms_billing_cancellations gbi,
803: -- pa_expenditure_items_all item ,
804: -- pa_expenditures_all pea,
805: -- gms_award_distributions gad ,
806: -- pa_resource_list_members prm
807: -- where gbi.expenditure_item_id = gad.expenditure_item_id
808: -- and item.expenditure_item_id = gad.expenditure_item_id
809: -- and gad.adl_line_num = gbi.adl_line_num
810: -- and item.expenditure_id = pea.expenditure_id

Line 842: pa_resource_list_members prm

838: --item.org_id -- Bug 4732065 commented for the bug 5481465
839: from gms_event_intersect gei,
840: pa_expenditure_items_all item,
841: gms_award_distributions gad,
842: pa_resource_list_members prm
843: where gei.expenditure_item_id = gad.expenditure_item_id
844: and gei.adl_line_num = gad.adl_line_num
845: and gei.event_type = 'REVENUE'
846: and gei.revenue_accumulated = 'N'

Line 876: pa_resource_list_members prm

872: from gms_burden_components gbc,
873: pa_expenditure_items_all item,
874: pa_expenditures_all pea,
875: gms_award_distributions gad,
876: pa_resource_list_members prm
877: where gbc.expenditure_item_id = gad.expenditure_item_id
878: and gbc.adl_line_num = gad.adl_line_num
879: and gbc.event_type = 'REVENUE'
880: and gbc.revenue_accumulated = 'N'

Line 910: pa_resource_list_members prm

906: from gms_billing_cancellations gbi,
907: pa_expenditure_items_all item,
908: pa_expenditures_all pea,
909: gms_award_distributions gad,
910: pa_resource_list_members prm
911: where gbi.expenditure_item_id = gad.expenditure_item_id
912: and item.expenditure_item_id = gad.expenditure_item_id
913: and gad.adl_line_num = gbi.adl_line_num
914: and item.expenditure_id = pea.expenditure_id

Line 943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;

939: x_budget_entry_method pa_budget_entry_methods.budget_entry_method%type;
940: x_categorization_code pa_budget_entry_methods.categorization_code%type;
941: x_resource_list_id gms_budget_versions.resource_list_id%type;
942: x_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
943: x_uncategorized_rlmi pa_resource_list_members.resource_list_member_id%type;
944: x_prev_list_processed number(30);
945: x_group_resource_type_id number(15);
946: x_group_resource_type_name varchar2(60);
947: x_resource_type_tab gms_res_map.resource_type_table;

Line 1140: from pa_resource_list_members

1136: Begin
1137:
1138: select resource_list_member_id
1139: into x_uncategorized_rlmi
1140: from pa_resource_list_members
1141: where resource_list_id = x_resource_list_id
1142: and NVL(migration_code,'M') ='M'; -- Bug 3626671
1143:
1144: Exception