DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_PERIOD_STATUSES

Line 2316: gmf_period_statuses gps,

2312: SELECT nvl(sum(cst.cmpnt_cost), 0)
2313: FROM cm_cmpt_dtl cst,
2314: gmf_organization_definitions god,
2315: gmf_fiscal_policies f,
2316: gmf_period_statuses gps,
2317: (
2318: select nvl (
2319: (
2320: SELECT x.cost_organization_id

Line 2351: gmf_period_statuses gps,

2347: IS
2348: SELECT gps.end_date
2349: FROM gmf_organization_definitions god,
2350: gmf_fiscal_policies f,
2351: gmf_period_statuses gps,
2352: (
2353: select nvl (
2354: (
2355: SELECT x.cost_organization_id

Line 2439: gmf_period_statuses gps

2435: IS
2436: SELECT gps.end_date
2437: FROM gmf_organization_definitions god,
2438: gmf_fiscal_policies f,
2439: gmf_period_statuses gps
2440: WHERE god.organization_id = v_organization_id
2441: AND f.legal_entity_id = god.legal_entity_id
2442: AND f.delete_mark = 0
2443: AND gps.delete_mark = 0

Line 2461: gmf_period_statuses gps

2457: SELECT nvl(sum(cst.nominal_cost), 0)
2458: FROM cm_rsrc_dtl cst,
2459: gmf_organization_definitions god,
2460: gmf_fiscal_policies f,
2461: gmf_period_statuses gps
2462: WHERE god.organization_id = v_organization_id
2463: AND f.legal_entity_id = god.legal_entity_id
2464: AND f.delete_mark = 0
2465: AND gps.delete_mark = 0