DBA Data[Home] [Help]

APPS.GMF_PERIODCLOSE_PVT dependencies on GMF_PERIOD_BALANCES_GT

Line 436: gmf_period_balances_gt pbt

432: pbt.lot_number,
433: SUM(pbt.primary_quantity) pri_qty,
434: SUM(NVL(pbt.secondary_quantity,0)) sec_qty
435: FROM
436: gmf_period_balances_gt pbt
437: WHERE
438: organization_id = p_organization_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
439: AND acct_period_id = p_acct_period_id /* Bug#5652481 ANTHIYAG 09-Nov-2006 */
440: GROUP BY

Line 489: INSERT INTO gmf_period_balances_gt (

485: FETCH c_onhand INTO r_onhand;
486: EXIT WHEN c_onhand%NOTFOUND;
487:
488: /* insert into balances table */
489: INSERT INTO gmf_period_balances_gt (
490: source_type_id,
491: acct_period_id,
492: organization_id,
493: cost_group_id,

Line 536: INSERT INTO gmf_period_balances_gt (

532: LOOP
533: FETCH c_txns INTO r_txns;
534: EXIT WHEN c_txns%NOTFOUND;
535:
536: INSERT INTO gmf_period_balances_gt (
537: source_type_id,
538: acct_period_id,
539: organization_id,
540: cost_group_id,