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 1480: -- Validate GL account info against GL_CODE_COMBINATIONS for each

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