APPS.CE_CSH_FCST_POP dependencies on HR_OPERATING_UNITS

Line 3227: FROM hr_operating_units

3223: cep_standard.debug('vendor_type');
3224:
3225: SELECT to_number(ORGANIZATION_ID)
3226: INTO l_legal_entity_id
3227: FROM hr_operating_units
3228: WHERE organization_id = C_req_rec.org_id;
3229: cep_standard.debug('legal_entity_id');
3230:
3231:

Line 3374: FROM hr_operating_units

3370: cep_standard.debug('vendor_type');
3371:
3372: SELECT to_number(ORGANIZATION_ID)
3373: INTO l_legal_entity_id
3374: FROM hr_operating_units
3375: WHERE organization_id = C_req_rec.org_id;
3376: cep_standard.debug('legal_entity_id');
3377:
3378:

Line 3538: FROM hr_operating_units

3534: cep_standard.debug('vendor_type_proj');
3535:
3536: SELECT to_number(ORGANIZATION_ID)
3537: INTO l_legal_entity_id
3538: FROM hr_operating_units
3539: WHERE organization_id = C_req_rec.org_id;
3540: cep_standard.debug('legal_entity_id_proj');
3541:
3542:

Line 3682: FROM hr_operating_units

3678: cep_standard.debug('vendor_type_proj');
3679:
3680: SELECT to_number(ORGANIZATION_ID)
3681: INTO l_legal_entity_id
3682: FROM hr_operating_units
3683: WHERE organization_id = C_req_rec.org_id;
3684: cep_standard.debug('legal_entity_id_proj');
3685:
3686: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 3938: FROM hr_operating_units

3934: cep_standard.debug('authorization_status');
3935:
3936: SELECT to_number(ORGANIZATION_ID)
3937: INTO l_legal_entity_id
3938: FROM hr_operating_units
3939: WHERE organization_id = C_req_rec.org_id;
3940: cep_standard.debug('legal_entity_id');
3941:
3942: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 4062: FROM hr_operating_units

4058: cep_standard.debug('authorization_status_proj');
4059:
4060: SELECT to_number(ORGANIZATION_ID)
4061: INTO l_legal_entity_id
4062: FROM hr_operating_units
4063: WHERE organization_id = C_req_rec.org_id;
4064: cep_standard.debug('legal_entity_id_proj');
4065:
4066: IF( (CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99) AND

Line 4973: FROM hr_operating_units

4969: WHERE project_id = CE_CASH_FCST.G_rp_project_id;
4970:
4971: SELECT to_number(ORGANIZATION_ID)
4972: INTO l_legal_entity_id
4973: FROM hr_operating_units
4974: WHERE organization_id = l_org_id;
4975:
4976: FOR C_rec IN C_period LOOP
4977: FOR C_budget_rec in C_budgets(C_rec.start_date, C_rec.end_date) LOOP