DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on GMF_FISCAL_POLICIES

Line 500: gmf_fiscal_policies gfp,

496: SELECT COUNT(*)
497: INTO l_period_count
498: FROM gmf_organization_definitions god,
499: gmf_period_statuses gps,
500: gmf_fiscal_policies gfp,
501: cm_mthd_mst mthd
502: WHERE god.organization_id = n.organization_id
503: AND gfp.legal_entity_id = god.legal_entity_id
504: AND mthd.cost_type_id = gfp.cost_type_id

Line 826: gmf_fiscal_policies gfp,

822: /* SELECT COUNT(*)
823: INTO l_period_count
824: FROM gmf_organization_definitions god,
825: gmf_period_statuses gps,
826: gmf_fiscal_policies gfp,
827: cm_mthd_mst mthd
828: WHERE god.organization_id = n.organization_id
829: AND gfp.legal_entity_id = god.legal_entity_id
830: AND mthd.cost_type_id = gfp.cost_type_id

Line 2264: FROM gmf_fiscal_policies gfp, cm_mthd_mst cmm

2260: AND gps.legal_entity_id = l_legal_entity_id;
2261:
2262: CURSOR Cur_cost_type IS
2263: SELECT cmm.cost_type
2264: FROM gmf_fiscal_policies gfp, cm_mthd_mst cmm
2265: WHERE gfp.cost_type_id = cmm.cost_type_id
2266: AND gfp.legal_entity_id = l_legal_entity_id
2267: AND cmm.cost_type <> 6
2268: UNION

Line 2270: FROM gmf_fiscal_policies gfp, cm_mthd_mst cmm1,cm_mthd_mst cmm2

2266: AND gfp.legal_entity_id = l_legal_entity_id
2267: AND cmm.cost_type <> 6
2268: UNION
2269: SELECT cmm2.cost_type
2270: FROM gmf_fiscal_policies gfp, cm_mthd_mst cmm1,cm_mthd_mst cmm2
2271: WHERE gfp.cost_type_id = cmm1.cost_type_id
2272: AND gfp.legal_entity_id = l_legal_entity_id
2273: AND cmm1.cost_type = 6
2274: AND cmm1.default_lot_cost_type_id = cmm2.cost_type_id;