APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_BUDGET_ASSIGNMENT_RANGES

Line 834: FROM GL_BUDGET_ASSIGNMENT_RANGES

830: X_Name gl_budget_entities.name%type;
831: bud_org_rec gl_budget_entities%rowtype;
832: /* Cursor to loop through all account ranges defined for a budget organization */
833: Cursor range_cur is SELECT *
834: FROM GL_BUDGET_ASSIGNMENT_RANGES
835: WHERE budget_entity_id = v_budget_entity_id;
836:
837: /* Cursor to loop through all funding budgets assigned to a specific account range */
838: CURSOR BC_CUR(p_range_id IN Number) IS

Line 845: v_new_range_id GL_BUDGET_ASSIGNMENT_RANGES.range_id%type;

841: v_range_id varchar2(100) := NULL;
842: V_Org_Description gl_budget_entities.description%type;
843: v_cbc_override gl_budorg_bc_options.funds_check_level_code%type;
844: v_coa_id gl_ledgers.chart_of_accounts_id%type;
845: v_new_range_id GL_BUDGET_ASSIGNMENT_RANGES.range_id%type;
846: l_full_path VARCHAR2(255);
847: /* Cursor to check whether the new organization is already migrated */
848: CURSOR budorg_cur(c_new_org_name IN VARCHAR2) IS
849: SELECT budget_entity_id from gl_budget_entities where name = c_new_org_name;

Line 861: FROM GL_BUDGET_ASSIGNMENT_RANGES_V

857: END IF;
858:
859: BEGIN
860: SELECT distinct budget_entity_id into v_budget_entity_id
861: FROM GL_BUDGET_ASSIGNMENT_RANGES_V
862: WHERE range_id IN
863: ( Select range_id From GL_BUDORG_BC_OPTIONS_V
864: Where FUNDING_BUDGET_NAME= P_BUDGET_NAME);
865: EXCEPTION

Line 1037: select gl_budget_assignment_ranges_s.NEXTVAL into v_new_range_id

1033:
1034: select chart_of_accounts_id into v_coa_id
1035: from gl_ledgers where ledger_id = g_cbc_ledger_id;
1036:
1037: select gl_budget_assignment_ranges_s.NEXTVAL into v_new_range_id
1038: from dual;
1039: BEGIN
1040: GL_BUD_ASSIGN_RANGE_PKG.Insert_Row(
1041: X_Rowid => v_range_id,