DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on HR_OPERATING_UNITS

Line 3303: FROM hr_operating_units

3299: cep_standard.debug('vendor_type');
3300:
3301: SELECT to_number(ORGANIZATION_ID)
3302: INTO l_legal_entity_id
3303: FROM hr_operating_units
3304: WHERE organization_id = C_req_rec.org_id;
3305: cep_standard.debug('legal_entity_id');
3306:
3307:

Line 3450: FROM hr_operating_units

3446: cep_standard.debug('vendor_type');
3447:
3448: SELECT to_number(ORGANIZATION_ID)
3449: INTO l_legal_entity_id
3450: FROM hr_operating_units
3451: WHERE organization_id = C_req_rec.org_id;
3452: cep_standard.debug('legal_entity_id');
3453:
3454:

Line 3614: FROM hr_operating_units

3610: cep_standard.debug('vendor_type_proj');
3611:
3612: SELECT to_number(ORGANIZATION_ID)
3613: INTO l_legal_entity_id
3614: FROM hr_operating_units
3615: WHERE organization_id = C_req_rec.org_id;
3616: cep_standard.debug('legal_entity_id_proj');
3617:
3618:

Line 3758: FROM hr_operating_units

3754: cep_standard.debug('vendor_type_proj');
3755:
3756: SELECT to_number(ORGANIZATION_ID)
3757: INTO l_legal_entity_id
3758: FROM hr_operating_units
3759: WHERE organization_id = C_req_rec.org_id;
3760: cep_standard.debug('legal_entity_id_proj');
3761:
3762: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 4014: FROM hr_operating_units

4010: cep_standard.debug('authorization_status');
4011:
4012: SELECT to_number(ORGANIZATION_ID)
4013: INTO l_legal_entity_id
4014: FROM hr_operating_units
4015: WHERE organization_id = C_req_rec.org_id;
4016: cep_standard.debug('legal_entity_id');
4017:
4018: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 4138: FROM hr_operating_units

4134: cep_standard.debug('authorization_status_proj');
4135:
4136: SELECT to_number(ORGANIZATION_ID)
4137: INTO l_legal_entity_id
4138: FROM hr_operating_units
4139: WHERE organization_id = C_req_rec.org_id;
4140: cep_standard.debug('legal_entity_id_proj');
4141:
4142: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 5059: FROM hr_operating_units

5055: WHERE project_id = CE_CASH_FCST.G_rp_project_id;
5056:
5057: SELECT to_number(ORGANIZATION_ID)
5058: INTO l_legal_entity_id
5059: FROM hr_operating_units
5060: WHERE organization_id = l_org_id;
5061:
5062: cep_standard.debug('l_org_id='||l_org_id||'l_legal_entity_id,='||l_legal_entity_id);
5063: