DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on HR_ORGANIZATION_UNITS

Line 2438: from hr_organization_units hru, pay_cost_allocation_keyflex pcak

2434: Cursor C_Org is
2435: Select hru.cost_allocation_keyflex_id ,
2436: hru.date_from,
2437: hru.date_to
2438: from hr_organization_units hru, pay_cost_allocation_keyflex pcak
2439: where hru.organization_id = le_organization_id
2440: and hru.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id;
2441:
2442: Cursor C_Segcount is

Line 3499: from hr_organization_units

3495: where business_group_id = p_business_group_id;
3496:
3497: Cursor C_Organizations is
3498: Select organization_id, name
3499: from hr_organization_units
3500: where business_group_id = p_business_group_id;
3501:
3502: l_lookup_type varchar2(30);
3503: l_lookup_code varchar2(30);