[Home] [Help]
3288: ELSE
3289:
3290: l_stmt_num := 35;
3291:
3292: /* The following query will be modified to refer to cst_organization_definitions
3293: as an impact of the HR-PROFILE option. */
3294:
3295: SELECT gp.period_set_name,
3296: gp.period_name,
3300: l_period_start_date
3301: FROM gl_periods gp,
3302: gl_sets_of_books gsob,
3303: /*org_organization_definitions ood */
3304: cst_organization_definitions ood
3305: WHERE ood.organization_id = l_organization_id
3306: AND gsob.set_of_books_id = ood.set_of_books_id
3307: AND gp.period_set_name = gsob.period_set_name
3308: AND gp.adjustment_period_flag = 'N'
7329: -- Get functional currency
7330: l_stmt_num := 40;
7331:
7332: /* The following select statement will be modified to refer to
7333: cst_organization_definitions as an impact of the HR-PROFILE option. */
7334:
7335: select ood.currency_code
7336: into l_func_currency
7337: from cst_organization_definitions ood
7333: cst_organization_definitions as an impact of the HR-PROFILE option. */
7334:
7335: select ood.currency_code
7336: into l_func_currency
7337: from cst_organization_definitions ood
7338: where ood.organization_id = l_org_id;
7339:
7340:
7341: -- Get txn value and base txn value
8591: l_stmt_num := 10;
8592:
8593: SELECT DISTINCT COD.currency_code
8594: INTO l_currency_code
8595: FROM cst_organization_definitions COD,
8596: wip_cost_txn_interface WCTI
8597: WHERE WCTI.group_id = p_wcti_group_id
8598: AND WCTI.organization_id = COD.organization_id;
8599: