APPS.GMF_CMCOMMON dependencies on GMF_FISCAL_POLICIES

Line 529: gmf_fiscal_policies f

525: f.legal_entity_id,
526: f.cost_type_id,
527: f.cost_basis
528: FROM hr_organization_information o,
529: gmf_fiscal_policies f
530: WHERE o.organization_id = v_organization_id
531: AND o.org_information_context = 'Accounting Information'
532: AND o.org_information2 = f.LEGAL_ENTITY_ID
533: AND f.delete_mark = 0;

Line 1336: gmf_fiscal_policies plc,

1332: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1333: SELECT m.cost_type_id,
1334: m.default_lot_cost_type_id
1335: FROM cm_mthd_mst m,
1336: gmf_fiscal_policies plc,
1337: hr_organization_information o
1338: WHERE o.organization_id = v_organization_id
1339: AND o.org_information_context = 'Accounting Information'
1340: AND plc.legal_entity_id = o.org_information2

Line 2493: gmf_fiscal_policies f,

2489: IS
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: (

Line 2528: gmf_fiscal_policies f,

2524: )
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: (

Line 2616: gmf_fiscal_policies f,

2612: )
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

Line 2638: gmf_fiscal_policies f,

2634: IS
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