APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on GL_CODE_COMBINATIONS

Line 97: -- COMMENT : Validate GL account info against GL_CODE_COMBINATIONS for each

93: --
94: -- x_valid_org_tbl OUT INV_OrgHierarchy_PVT.OrgID_tbl_type
95: -- Shortened Organization List containing only valid organizations
96: --
97: -- COMMENT : Validate GL account info against GL_CODE_COMBINATIONS for each
98: -- organization in the Organization List
99: -- Update global pl/sql table G_ORG_GL_REV_TBL set the valid_flag
100: -- to 'Y' for the successful validation
101: -- Otherwise, set to 'N' for NOT a valid code combination

Line 129: gl_code_combinations

125: IS
126: SELECT
127: code_combination_id
128: FROM
129: gl_code_combinations
130: WHERE chart_of_accounts_id = c_chart_of_accounts_id
131: AND code_combination_id = c_code_combination_id
132: AND nvl(start_date_active,SYSDATE) <= SYSDATE
133: AND nvl(end_date_active,SYSDATE) >= SYSDATE;

Line 1484: -- Validate GL account info against GL_CODE_COMBINATIONS for each

1480: -- ====================================================================
1481: Retrieve_gl_rev(p_org_tbl => l_org_tbl);
1482:
1483: -- =====================================================================
1484: -- Validate GL account info against GL_CODE_COMBINATIONS for each
1485: -- organization in the Organization List
1486: -- Update global pl/sql table G_ORG_GL_REV_TBL set the valid_flag to 'Y'
1487: -- for the successful validation
1488: -- Otherwise, set to 'N' for NOT a valid code combination