APPS.GHG_ORGANIZATION_MAPPINGS_PKG dependencies on GHG_ORG_PROJECT_MAPPINGS_V

Line 236: FROM GHG_ORG_PROJECT_MAPPINGS_V xnpm

232: v_debug_info := 'Retrieving organization project mapping for project/task ' || x_project_number || '/' || x_task_number || '(distribution line ' || x_distribution_line_number ||')';
233:
234: SELECT ghg_organization_id
235: INTO v_ghg_organization_id
236: FROM GHG_ORG_PROJECT_MAPPINGS_V xnpm
237: WHERE x_project_number BETWEEN xnpm.from_project_number AND xnpm.to_project_number
238: AND x_task_number BETWEEN xnpm.from_task_number AND xnpm.to_task_number
239: AND x_gl_date BETWEEN NVL(xnpm.start_date, sysdate - 1)
240: AND NVL(xnpm.end_date, sysdate + 1);