DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on CST_ORGANIZATION_DEFINITIONS

Line 3070: /* The following query will be modified to refer to cst_organization_definitions

3066: ELSE
3067:
3068: l_stmt_num := 35;
3069:
3070: /* The following query will be modified to refer to cst_organization_definitions
3071: as an impact of the HR-PROFILE option. */
3072:
3073: SELECT gp.period_set_name,
3074: gp.period_name,

Line 3082: cst_organization_definitions ood

3078: l_period_start_date
3079: FROM gl_periods gp,
3080: gl_sets_of_books gsob,
3081: /*org_organization_definitions ood */
3082: cst_organization_definitions ood
3083: WHERE ood.organization_id = l_organization_id
3084: AND gsob.set_of_books_id = ood.set_of_books_id
3085: AND gp.period_set_name = gsob.period_set_name
3086: AND gp.adjustment_period_flag = 'N'

Line 6919: cst_organization_definitions as an impact of the HR-PROFILE option. */

6915: -- Get functional currency
6916: l_stmt_num := 40;
6917:
6918: /* The following select statement will be modified to refer to
6919: cst_organization_definitions as an impact of the HR-PROFILE option. */
6920:
6921: select ood.currency_code
6922: into l_func_currency
6923: from cst_organization_definitions ood

Line 6923: from cst_organization_definitions ood

6919: cst_organization_definitions as an impact of the HR-PROFILE option. */
6920:
6921: select ood.currency_code
6922: into l_func_currency
6923: from cst_organization_definitions ood
6924: where ood.organization_id = l_org_id;
6925:
6926:
6927: -- Get txn value and base txn value

Line 8022: FROM cst_organization_definitions COD,

8018: l_stmt_num := 10;
8019:
8020: SELECT DISTINCT COD.currency_code
8021: INTO l_currency_code
8022: FROM cst_organization_definitions COD,
8023: wip_cost_txn_interface WCTI
8024: WHERE WCTI.group_id = p_wcti_group_id
8025: AND WCTI.organization_id = COD.organization_id;
8026: