APPS.GMF_PERIODCLOSE_PUB dependencies on ORG_ACCT_PERIODS

Line 159: FROM org_acct_periods

155:
156: l_stmt_num := 21;
157: SELECT period_start_date
158: INTO l_le_closing_fm_date
159: FROM org_acct_periods
160: WHERE acct_period_id = p_closing_period
161: AND organization_id = p_org_id;
162:
163: l_stmt_num := 22;

Line 338: FROM org_acct_periods

334:
335: -- Finds whether there are any prior open periods
336: CURSOR get_prior_open_period IS
337: SELECT acct_period_id
338: FROM org_acct_periods
339: WHERE organization_id = p_org_id
340: AND schedule_close_date = (SELECT MIN(oap1.schedule_close_date)
341: FROM org_acct_periods oap1, org_acct_periods oap2
342: WHERE

Line 341: FROM org_acct_periods oap1, org_acct_periods oap2

337: SELECT acct_period_id
338: FROM org_acct_periods
339: WHERE organization_id = p_org_id
340: AND schedule_close_date = (SELECT MIN(oap1.schedule_close_date)
341: FROM org_acct_periods oap1, org_acct_periods oap2
342: WHERE
343: oap1.organization_id = p_org_id
344: AND (oap1.open_flag = 'Y' or oap1.open_flag = 'P')
345: and oap2.organization_id = oap1.organization_id

Line 353: FROM org_acct_periods

349:
350: -- Finds whether the period is closed or not
351: CURSOR check_current_period_open IS
352: SELECT acct_period_id
353: FROM org_acct_periods
354: WHERE organization_id = p_org_id
355: AND acct_period_id = p_closing_acct_period_id
356: AND (open_flag = 'Y' or open_flag = 'P');
357:

Line 359: -- Finds the next period in org_acct_periods

355: AND acct_period_id = p_closing_acct_period_id
356: AND (open_flag = 'Y' or open_flag = 'P');
357:
358:
359: -- Finds the next period in org_acct_periods
360: /* CURSOR get_next_open_period IS
361: SELECT MIN(acct_period_id)
362: FROM org_acct_periods
363: WHERE organization_id = p_org_id

Line 362: FROM org_acct_periods

358:
359: -- Finds the next period in org_acct_periods
360: /* CURSOR get_next_open_period IS
361: SELECT MIN(acct_period_id)
362: FROM org_acct_periods
363: WHERE organization_id = p_org_id
364: AND acct_period_id > p_closing_acct_period_id;
365:
366: /* INVCONV

Line 379: FROM org_acct_periods

375: -- Checks if period is already in process of closing
376: /* rseshadr - Enabled the check below */
377: CURSOR check_reclose_period IS
378: SELECT acct_period_id
379: FROM org_acct_periods
380: WHERE organization_id = p_org_id
381: AND acct_period_id = p_closing_acct_period_id
382: AND period_close_date IS NOT NULL
383: AND open_flag = 'P';

Line 613: UPDATE org_acct_periods

609: * rseshadr - Set status to Processing
610: * The period will be set to Closed once
611: * balances are compiled
612: **/
613: UPDATE org_acct_periods
614: SET
615: open_flag = 'P',
616: period_close_date = trunc(sysdate),
617: last_update_date = trunc(sysdate),

Line 758: FROM org_acct_periods oap,

754: -- Now using OPM's Prior Period, get the Inventory Period Year and Number.
755: --
756: SELECT oap.period_year, oap.period_num
757: INTO x_inv_period_year, x_inv_period_num
758: FROM org_acct_periods oap,
759: gmf_period_statuses gps,
760: hr_organization_information hoi
761: WHERE gps.period_id = l_prev_period_id
762: AND gps.legal_entity_id = hoi.org_information2

Line 774: FROM org_acct_periods oap,

770: -- Now see whether period is closed for all Process Orgs.
771: --
772: SELECT SUM(decode(open_flag,'Y',1,'P',1, 0))
773: INTO l_open_periods_cnt
774: FROM org_acct_periods oap,
775: mtl_parameters mp,
776: hr_organization_information hoi
777: WHERE hoi.org_information2 = p_legal_entity_id
778: AND hoi.org_information_context = 'Accounting Information'