APPS.GMF_MIGRATION dependencies on GMF_PERIOD_BALANCES

Line 8926: G_Table_name := 'GMF_PERIOD_BALANCES';

8922:
8923: BEGIN
8924:
8925: G_Migration_run_id := P_migration_run_id;
8926: G_Table_name := 'GMF_PERIOD_BALANCES';
8927: G_Context := 'Period Balances Migration';
8928: X_failure_count := 0;
8929:
8930: /********************************

Line 8954: INSERT INTO gmf_period_balances

8950: FROM ic_perd_bal
8951: WHERE whse_code = i.whse_code
8952: AND period_id = i.prior_period_id;
8953:
8954: INSERT INTO gmf_period_balances
8955: (
8956: period_balance_id,
8957: acct_period_id,
8958: organization_id,

Line 8982: SELECT gmf_period_balances_s.NEXTVAL,

8978: program_id,
8979: program_update_date
8980: )
8981: (
8982: SELECT gmf_period_balances_s.NEXTVAL,
8983: i.acct_period_id,
8984: i.organization_id,
8985: decode(i.subinventory_ind_flag, 'N', NULL, e.default_cost_group_id),
8986: decode(i.subinventory_ind_flag, 'N', NULL, e.secondary_inventory_name),

Line 9025: FROM gmf_period_balances x

9021: AND d.whse_code = a.whse_code
9022: AND d.location = a.location
9023: AND NOT EXISTS (
9024: SELECT 'X'
9025: FROM gmf_period_balances x
9026: WHERE x.acct_period_id = i.acct_period_id
9027: AND x.organization_id = i.organization_id
9028: AND x.inventory_item_id = b.inventory_item_id
9029: AND nvl(x.subinventory_code, '~') = nvl(decode(i.subinventory_ind_flag, 'N', NULL, e.secondary_inventory_name), '~')