DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on GMF_FISCAL_POLICIES

Line 525: gmf_fiscal_policies f

521: f.legal_entity_id,
522: f.cost_type_id,
523: f.cost_basis
524: FROM hr_organization_information o,
525: gmf_fiscal_policies f
526: WHERE o.organization_id = v_organization_id
527: AND o.org_information_context = 'Accounting Information'
528: AND o.org_information2 = f.LEGAL_ENTITY_ID
529: AND f.delete_mark = 0;

Line 1164: gmf_fiscal_policies plc,

1160: CURSOR Cur_get_cost_mthd ( v_organization_id IN NUMBER ) IS
1161: SELECT m.cost_type_id,
1162: m.default_lot_cost_type_id
1163: FROM cm_mthd_mst m,
1164: gmf_fiscal_policies plc,
1165: hr_organization_information o
1166: WHERE o.organization_id = v_organization_id
1167: AND o.org_information_context = 'Accounting Information'
1168: AND plc.legal_entity_id = o.org_information2

Line 2315: gmf_fiscal_policies f,

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

Line 2350: gmf_fiscal_policies f,

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

Line 2438: gmf_fiscal_policies f,

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

Line 2460: gmf_fiscal_policies f,

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