[Home] [Help]
494:
495:
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
820: -- PK Bug 8472152 Commented next statement. Null vib records from past period should be updated as well
821:
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
2282: and transaction_date <= l_enddate
2283: and transaction_action_id NOT IN (2, 28)
2284: and opm_costed_flag IS NULL
2285: and organization_id IN (SELECT organization_id
2286: FROM gmf_organization_definitions
2287: WHERE legal_entity_id = l_legal_entity_id);
2288:
2289:
2290:
2420: WHERE batches.batch_id = l_batch_id
2421: AND batches.organization_id = l_org_id
2422: AND batches.organization_id IN
2423: (SELECT organization_id
2424: FROM gmf_organization_definitions
2425: WHERE legal_entity_id = l_legal_entity_id);
2426:
2427:
2428: ELSIF (l_batch_id IS NULL AND l_org_id IS NOT NULL) THEN
2473: ) batches
2474: WHERE batches.organization_id = l_org_id
2475: AND batches.organization_id IN
2476: (SELECT organization_id
2477: FROM gmf_organization_definitions
2478: WHERE legal_entity_id = l_legal_entity_id);
2479:
2480: ELSIF (l_batch_id IS NULL AND l_org_id IS NULL) THEN
2481:
2524: AND h.plan_start_date >= l_startdate
2525: ) batches
2526: WHERE batches.organization_id IN
2527: (SELECT organization_id
2528: FROM gmf_organization_definitions
2529: WHERE legal_entity_id = l_legal_entity_id);
2530:
2531: END IF;
2532: