APPS.CST_PRJMFG_COST_COLLECTOR dependencies on CST_ORGANIZATION_DEFINITIONS

Line 1658: FROM cst_organization_definitions COD

1654: INTO l_business_group_name
1655: FROM hr_all_organization_units_tl HAOUT
1656: WHERE HAOUT.organization_id =
1657: (SELECT COD.business_group_id
1658: FROM cst_organization_definitions COD
1659: WHERE COD.organization_id = p_org_id)
1660: AND haout.language = USERENV('LANG');
1661: END IF;
1662: end if;

Line 2796: FROM cst_organization_definitions cod

2792: l_stmt_num := 40;
2793:
2794: SELECT currency_code
2795: INTO l_xfer_currency_code
2796: FROM cst_organization_definitions cod
2797: WHERE cod.organization_id = p_transfer_organization_id;
2798:
2799: END IF;
2800:

Line 6998: from cst_organization_definitions

6994: END;
6995: l_stmt_num := 53;
6996: select currency_code
6997: into l_cc_functional_currency
6998: from cst_organization_definitions
6999: where organization_id = l_mta_organization_id;
7000:
7001: If l_debug = 'Y' then
7002: IF l_cc_rate IS NULL then

Line 7784: id that we will obtain from cst_organization_definitions for that particular organization_id to

7780: End If;
7781:
7782: l_stmt_num := 51;
7783: /*Bug 8398299: We will pass the business_group_name from hr_all_organization_units_tl from the business group
7784: id that we will obtain from cst_organization_definitions for that particular organization_id to
7785: prevent the error: PA_TOO_MANY_ORGN when they have activated the profile HR:Cross Business Group
7786: */
7787: IF (l_cross_bg_profile = 'Y') THEN
7788: SELECT HAOUT.name

Line 7793: FROM cst_organization_definitions COD

7789: INTO l_business_group_name
7790: FROM hr_all_organization_units_tl HAOUT
7791: WHERE HAOUT.organization_id =
7792: (SELECT COD.business_group_id
7793: FROM cst_organization_definitions COD
7794: WHERE COD.organization_id = p_organization_id)
7795: AND haout.language = USERENV('LANG');
7796: END IF;
7797: