DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_PERIOD_STATUSES

Line 2494: gmf_period_statuses gps,

2490: SELECT nvl(sum(cst.cmpnt_cost), 0)
2491: FROM cm_cmpt_dtl cst,
2492: gmf_organization_definitions god,
2493: gmf_fiscal_policies f,
2494: gmf_period_statuses gps,
2495: (
2496: select nvl (
2497: (
2498: SELECT x.cost_organization_id

Line 2529: gmf_period_statuses gps,

2525: IS
2526: SELECT gps.end_date
2527: FROM gmf_organization_definitions god,
2528: gmf_fiscal_policies f,
2529: gmf_period_statuses gps,
2530: (
2531: select nvl (
2532: (
2533: SELECT x.cost_organization_id

Line 2617: gmf_period_statuses gps

2613: IS
2614: SELECT gps.end_date
2615: FROM gmf_organization_definitions god,
2616: gmf_fiscal_policies f,
2617: gmf_period_statuses gps
2618: WHERE god.organization_id = v_organization_id
2619: AND f.legal_entity_id = god.legal_entity_id
2620: AND f.delete_mark = 0
2621: AND gps.delete_mark = 0

Line 2639: gmf_period_statuses gps

2635: SELECT nvl(sum(cst.nominal_cost), 0)
2636: FROM cm_rsrc_dtl cst,
2637: gmf_organization_definitions god,
2638: gmf_fiscal_policies f,
2639: gmf_period_statuses gps
2640: WHERE god.organization_id = v_organization_id
2641: AND f.legal_entity_id = god.legal_entity_id
2642: AND f.delete_mark = 0
2643: AND gps.delete_mark = 0