APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 70: FROM HR_ALL_ORGANIZATION_UNITS u

66: SELECT
67: 0 rn,
68: 0 level1,
69: ORGANIZATION_ID
70: FROM HR_ALL_ORGANIZATION_UNITS u
71: WHERE ORGANIZATION_ID = p_start_org_id
72: and business_group_id = p_business_group_id
73: and exists
74: (select null from per_org_structure_elements e

Line 644: l_org_name hr_all_organization_units.name%type;

640: ,p_start_date date
641: ,p_end_date date
642: ) is
643: l_proc_name varchar2(61) := 'org_pos_analysis' ;
644: l_org_name hr_all_organization_units.name%type;
645: --
646: l_parameter1_value varchar2(100);
647: l_parameter2_value varchar2(100);
648: l_parameter3_value varchar2(100);

Line 659: from hr_all_organization_units u

655: --
656: -- Cursor to fetch Organization name
657: cursor c_org_name(p_org_id number) is
658: select name
659: from hr_all_organization_units u
660: where organization_id = p_org_id;
661: -- Cursor to fetch the table_route_id of the table_alias
662: cursor c_table_route(p_table_alias varchar2) is
663: SELECT

Line 1398: from hr_all_organization_units u

1394: cursor c_org(p_org_structure_version_id number, p_start_org_id number,p_effective_date date) is
1395: select 0 rn,
1396: 0 level1,
1397: organization_id
1398: from hr_all_organization_units u
1399: where organization_id = p_start_org_id
1400: and business_group_id = p_business_group_id
1401: and exists
1402: (select null from per_org_structure_elements e

Line 1428: from hr_all_organization_units

1424: cursor c_all_org(p_business_group_id number, p_effective_date date) is
1425: select rownum rn,
1426: 0 level1,
1427: organization_id
1428: from hr_all_organization_units
1429: where business_group_id = p_business_group_id
1430: and INTERNAL_EXTERNAL_FLAG ='INT'
1431: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);
1432: --

Line 2800: l_org_name hr_all_organization_units.name%type;

2796: ,p_start_date date
2797: ,p_end_date date
2798: ) is
2799: l_proc_name varchar2(61) := 'org_temp' ;
2800: l_org_name hr_all_organization_units.name%type;
2801: --
2802: -- Cursor to fetch Organization name
2803: --
2804: cursor c_org_name(p_org_id number) is

Line 2806: from hr_all_organization_units u

2802: -- Cursor to fetch Organization name
2803: --
2804: cursor c_org_name(p_org_id number) is
2805: select name
2806: from hr_all_organization_units u
2807: where organization_id = p_org_id;
2808: --
2809: --
2810: -- Cursor to fetch the table_route_id of the table_alias

Line 3307: from hr_all_organization_units u

3303: cursor c_org(p_org_structure_version_id number, p_start_org_id number,p_effective_date date) is
3304: select 0 rn,
3305: 0 level1,
3306: organization_id
3307: from hr_all_organization_units u
3308: where organization_id = p_start_org_id
3309: and business_group_id = p_business_group_id
3310: and exists
3311: (select null from per_org_structure_elements e

Line 3336: from hr_all_organization_units

3332: cursor c_all_org(p_business_group_id number, p_effective_date date) is
3333: select rownum rn,
3334: 0 level1,
3335: organization_id
3336: from hr_all_organization_units
3337: where business_group_id = p_business_group_id
3338: and INTERNAL_EXTERNAL_FLAG ='INT'
3339: and p_effective_date between date_from and nvl(date_to, hr_general.end_of_time);
3340: --