eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on HR_LOOKUPS

Line 104: occupational_level_id hr_lookups.lookup_code%type,

100: (
101: payroll_id per_all_assignments_f.payroll_id%type,
102: legal_entity_id hr_all_organization_units.organization_id%type,
103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
107: occupational_category hr_lookups.meaning%type,
108: race per_all_people_f.per_information4%type,

Line 105: occupational_category_id hr_lookups.lookup_code%type,

101: payroll_id per_all_assignments_f.payroll_id%type,
102: legal_entity_id hr_all_organization_units.organization_id%type,
103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
107: occupational_category hr_lookups.meaning%type,
108: race per_all_people_f.per_information4%type,
109: sex per_all_people_f.sex%type,

Line 106: occupational_level hr_lookups.meaning%type,

102: legal_entity_id hr_all_organization_units.organization_id%type,
103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
107: occupational_category hr_lookups.meaning%type,
108: race per_all_people_f.per_information4%type,
109: sex per_all_people_f.sex%type,
110: annual_income number

Line 107: occupational_category hr_lookups.meaning%type,

103: legal_entity hr_all_organization_units.name%type,
104: occupational_level_id hr_lookups.lookup_code%type,
105: occupational_category_id hr_lookups.lookup_code%type,
106: occupational_level hr_lookups.meaning%type,
107: occupational_category hr_lookups.meaning%type,
108: race per_all_people_f.per_information4%type,
109: sex per_all_people_f.sex%type,
110: annual_income number
111: );

Line 124: occupational_code_id hr_lookups.lookup_code%type,

120: type r_Encome_diff_rec is record
121: (
122: legal_entity_id hr_all_organization_units.organization_id%type,
123: legal_entity hr_all_organization_units.NAME%type,
124: occupational_code_id hr_lookups.lookup_code%type,
125: occupational_code hr_lookups.meaning%type,
126: ma number,
127: mc number,
128: mi number,

Line 125: occupational_code hr_lookups.meaning%type,

121: (
122: legal_entity_id hr_all_organization_units.organization_id%type,
123: legal_entity hr_all_organization_units.NAME%type,
124: occupational_code_id hr_lookups.lookup_code%type,
125: occupational_code hr_lookups.meaning%type,
126: ma number,
127: mc number,
128: mi number,
129: mw number,

Line 157: occupational_level_id hr_lookups.lookup_code%type,

153: (
154: payroll_id per_all_assignments_f.payroll_id%type,
155: legal_entity_id hr_all_organization_units.organization_id%type,
156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
160: occupational_category hr_lookups.meaning%type,
161: race per_all_people_f.per_information4%type,

Line 158: occupational_category_id hr_lookups.lookup_code%type,

154: payroll_id per_all_assignments_f.payroll_id%type,
155: legal_entity_id hr_all_organization_units.organization_id%type,
156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
160: occupational_category hr_lookups.meaning%type,
161: race per_all_people_f.per_information4%type,
162: sex per_all_people_f.sex%type,

Line 159: occupational_level hr_lookups.meaning%type,

155: legal_entity_id hr_all_organization_units.organization_id%type,
156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
160: occupational_category hr_lookups.meaning%type,
161: race per_all_people_f.per_information4%type,
162: sex per_all_people_f.sex%type,
163: employment_type varchar2(30), --Permanent/Non Permanent

Line 160: occupational_category hr_lookups.meaning%type,

156: legal_entity hr_all_organization_units.name%type,
157: occupational_level_id hr_lookups.lookup_code%type,
158: occupational_category_id hr_lookups.lookup_code%type,
159: occupational_level hr_lookups.meaning%type,
160: occupational_category hr_lookups.meaning%type,
161: race per_all_people_f.per_information4%type,
162: sex per_all_people_f.sex%type,
163: employment_type varchar2(30), --Permanent/Non Permanent
164: foreigner varchar2(30), --Foreigner or not

Line 196: g_lev_name hr_lookups.meaning%type;

192: g_job_name per_jobs.name%type;
193: g_job_report_date date;
194: g_job_asg_id per_all_assignments_f.assignment_id%type;
195:
196: g_lev_name hr_lookups.meaning%type;
197: g_lev_report_date date;
198: g_lev_asg_id per_all_assignments_f.assignment_id%type;
199:
200: g_cat_name hr_lookups.meaning%type;

Line 200: g_cat_name hr_lookups.meaning%type;

196: g_lev_name hr_lookups.meaning%type;
197: g_lev_report_date date;
198: g_lev_asg_id per_all_assignments_f.assignment_id%type;
199:
200: g_cat_name hr_lookups.meaning%type;
201: g_cat_report_date date;
202: g_cat_asg_id per_all_assignments_f.assignment_id%type;
203:
204: g_lev_flex pay_user_column_instances_f.value%type := null;

Line 208: g_f_type_name hr_lookups.meaning%type;

204: g_lev_flex pay_user_column_instances_f.value%type := null;
205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;
210: g_Func_segment pay_user_column_instances_f.value%type := null;
211:
212: g_high1 number := 0;

Line 581: p_occupational_level_cat in hr_lookups.meaning%type,

577: p_report_date in per_all_assignments_f.effective_end_date%type,
578: p_business_group_id in per_all_assignments_f.business_group_id%type,
579: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
580: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
581: p_occupational_level_cat in hr_lookups.meaning%type,
582: p_lookup_code in hr_lookups.lookup_code%type,
583: p_occupational_type in varchar2, -- CAT = Category, LEV = Level
584: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
585: ) return number is

Line 582: p_lookup_code in hr_lookups.lookup_code%type,

578: p_business_group_id in per_all_assignments_f.business_group_id%type,
579: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
580: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
581: p_occupational_level_cat in hr_lookups.meaning%type,
582: p_lookup_code in hr_lookups.lookup_code%type,
583: p_occupational_type in varchar2, -- CAT = Category, LEV = Level
584: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
585: ) return number is
586:

Line 704: p_occupational_level_cat in hr_lookups.meaning%type,

700: p_report_date in per_all_assignments_f.effective_end_date%type,
701: p_business_group_id in per_all_assignments_f.business_group_id%type,
702: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
703: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
704: p_occupational_level_cat in hr_lookups.meaning%type,
705: p_lookup_code in hr_lookups.lookup_code%type,
706: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories
707: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
708: ) return number is

Line 705: p_lookup_code in hr_lookups.lookup_code%type,

701: p_business_group_id in per_all_assignments_f.business_group_id%type,
702: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
703: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
704: p_occupational_level_cat in hr_lookups.meaning%type,
705: p_lookup_code in hr_lookups.lookup_code%type,
706: p_occupational_type in varchar2, -- LEV = Levels, CAT = Categories
707: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
708: ) return number is
709:

Line 1370: l_name hr_lookups.meaning%type;

1366: p_grade_id in per_all_assignments_f.grade_id%type,
1367: p_position_id in per_all_assignments_f.position_id%type
1368: ) return varchar2 is
1369:
1370: l_name hr_lookups.meaning%type;
1371: l_sql varchar2(32767);
1372: begin
1373:
1374: hr_utility.set_location('p_job_id '||p_job_id , 30);

Line 1505: l_name hr_lookups.meaning%type;

1501: ) return varchar2 is
1502:
1503: l_sql varchar2(32767);
1504: l_indicator NUMBER;
1505: l_name hr_lookups.meaning%type;
1506: l_code hr_lookups.lookup_code%type;
1507: l_lookup_type hr_lookups.lookup_type%type;
1508:
1509: begin

Line 1506: l_code hr_lookups.lookup_code%type;

1502:
1503: l_sql varchar2(32767);
1504: l_indicator NUMBER;
1505: l_name hr_lookups.meaning%type;
1506: l_code hr_lookups.lookup_code%type;
1507: l_lookup_type hr_lookups.lookup_type%type;
1508:
1509: begin
1510: -- Added 08-Jan-2008

Line 1507: l_lookup_type hr_lookups.lookup_type%type;

1503: l_sql varchar2(32767);
1504: l_indicator NUMBER;
1505: l_name hr_lookups.meaning%type;
1506: l_code hr_lookups.lookup_code%type;
1507: l_lookup_type hr_lookups.lookup_type%type;
1508:
1509: begin
1510: -- Added 08-Jan-2008
1511: l_indicator := 0;

Line 1518: FROM hr_lookups

1514: hr_utility.set_location('p_segment'||p_segment,20);
1515: IF p_type = 'CAT' then
1516: Select COUNT(*)
1517: INTO l_indicator
1518: FROM hr_lookups
1519: WHERE lookup_type = 'ZA_WSP_OCCUPATIONAL_CATEGORIES';
1520: END IF ;
1521:
1522: hr_utility.set_location('l_indicator'||l_indicator, 20);

Line 1543: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '

1539: if p_flex = 'Job' then
1540:
1541: begin
1542: if p_job_id is not null then
1543: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
1544: || to_char(p_job_id)
1545: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1546: || p_type || ''' and hl.lookup_code = pjd.' || p_segment;
1547:

Line 1566: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '

1562: elsif p_flex = 'Grade' then
1563:
1564: begin
1565: if p_grade_id is not null then
1566: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
1567: || to_char(p_grade_id)
1568: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1569: || p_type || ''' and hl.lookup_code = pgd.' || p_segment;
1570:

Line 1589: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '

1585: elsif p_flex = 'Position' then
1586:
1587: begin
1588: if p_position_id is not null then
1589: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
1590: || to_char(p_position_id)
1591: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1592: || p_type || ''' and hl.lookup_code = ppd.' || p_segment;
1593:

Line 1781: p_meaning in hr_lookups.meaning%type

1777:
1778: -- This function returns the lookup_code from the user tables.
1779: function get_lookup_code
1780: (
1781: p_meaning in hr_lookups.meaning%type
1782: ) return varchar2 is
1783:
1784: l_lookup_code hr_lookups.lookup_code%type;
1785:

Line 1784: l_lookup_code hr_lookups.lookup_code%type;

1780: (
1781: p_meaning in hr_lookups.meaning%type
1782: ) return varchar2 is
1783:
1784: l_lookup_code hr_lookups.lookup_code%type;
1785:
1786: begin
1787:
1788: select distinct hl.lookup_code

Line 1790: from hr_lookups hl

1786: begin
1787:
1788: select distinct hl.lookup_code
1789: into l_lookup_code
1790: from hr_lookups hl
1791: where hl.lookup_type in ('ZA_EMP_EQ_OCCUPATIONAL_CAT', 'ZA_EMP_EQ_OCCUPATIONAL_LEV')
1792: and hl.meaning = p_meaning;
1793:
1794: return l_lookup_code;

Line 1871: from hr_lookups hl,

1867: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
1868: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
1869: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
1870: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
1871: from hr_lookups hl,
1872: hr_lookups hl1,
1873: hr_lookups hl2,
1874: hr_all_organization_units haou,
1875: per_assignment_extra_info paei,

Line 1872: hr_lookups hl1,

1868: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
1869: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
1870: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
1871: from hr_lookups hl,
1872: hr_lookups hl1,
1873: hr_lookups hl2,
1874: hr_all_organization_units haou,
1875: per_assignment_extra_info paei,
1876: per_all_assignments_f paaf,

Line 1873: hr_lookups hl2,

1869: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
1870: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
1871: from hr_lookups hl,
1872: hr_lookups hl1,
1873: hr_lookups hl2,
1874: hr_all_organization_units haou,
1875: per_assignment_extra_info paei,
1876: per_all_assignments_f paaf,
1877: per_all_people_f papf

Line 1956: from hr_lookups hl

1952: 0 FC,
1953: 0 FI,
1954: 0 FW,
1955: 0 total
1956: from hr_lookups hl
1957: , hr_all_organization_units haou
1958: where not exists
1959: (
1960: select 'X'

Line 2013: from hr_lookups hl

2009: 0 FC,
2010: 0 FI,
2011: 0 FW,
2012: 0 total
2013: from hr_lookups hl
2014: , hr_all_organization_units haou
2015: where not exists
2016: (
2017: select 'X'

Line 2090: from hr_lookups hl,

2086: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
2087: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2088: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2089: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2090: from hr_lookups hl,
2091: hr_lookups hl1,
2092: hr_lookups hl2,
2093: hr_all_organization_units haou,
2094: per_assignment_extra_info paei,

Line 2091: hr_lookups hl1,

2087: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2088: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2089: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2090: from hr_lookups hl,
2091: hr_lookups hl1,
2092: hr_lookups hl2,
2093: hr_all_organization_units haou,
2094: per_assignment_extra_info paei,
2095: per_all_assignments_f paaf,

Line 2092: hr_lookups hl2,

2088: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2089: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2090: from hr_lookups hl,
2091: hr_lookups hl1,
2092: hr_lookups hl2,
2093: hr_all_organization_units haou,
2094: per_assignment_extra_info paei,
2095: per_all_assignments_f paaf,
2096: per_all_people_f papf

Line 2174: from hr_lookups hl

2170: 0 FC,
2171: 0 FI,
2172: 0 FW,
2173: 0 total
2174: from hr_lookups hl
2175: , hr_all_organization_units haou
2176: where not exists
2177: (
2178: select 'X'

Line 2232: from hr_lookups hl

2228: 0 FC,
2229: 0 FI,
2230: 0 FW,
2231: 0 total
2232: from hr_lookups hl
2233: , hr_all_organization_units haou
2234: where not exists
2235: (
2236: select 'X'

Line 2327: from hr_lookups hl,

2323: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
2324: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2325: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2326: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2327: from hr_lookups hl,
2328: hr_lookups hl1,
2329: hr_lookups hl2,
2330: hr_all_organization_units haou,
2331: per_assignment_extra_info paei,

Line 2328: hr_lookups hl1,

2324: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2325: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2326: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2327: from hr_lookups hl,
2328: hr_lookups hl1,
2329: hr_lookups hl2,
2330: hr_all_organization_units haou,
2331: per_assignment_extra_info paei,
2332: per_all_assignments_f paaf,

Line 2329: hr_lookups hl2,

2325: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2326: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2327: from hr_lookups hl,
2328: hr_lookups hl1,
2329: hr_lookups hl2,
2330: hr_all_organization_units haou,
2331: per_assignment_extra_info paei,
2332: per_all_assignments_f paaf,
2333: per_all_people_f papf

Line 2421: from hr_lookups hl

2417: 0 FC,
2418: 0 FI,
2419: 0 FW,
2420: 0 total
2421: from hr_lookups hl
2422: , hr_all_organization_units haou
2423: where not exists
2424: (
2425: select 'X'

Line 2478: from hr_lookups hl

2474: 0 FC,
2475: 0 FI,
2476: 0 FW,
2477: 0 total
2478: from hr_lookups hl
2479: , hr_all_organization_units haou
2480: where not exists
2481: (
2482: select 'X'

Line 2574: from hr_lookups hl,

2570: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
2571: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2572: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2574: from hr_lookups hl,
2575: hr_lookups hl1,
2576: hr_lookups hl2,
2577: hr_all_organization_units haou,
2578: per_assignment_extra_info paei,

Line 2575: hr_lookups hl1,

2571: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2572: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2574: from hr_lookups hl,
2575: hr_lookups hl1,
2576: hr_lookups hl2,
2577: hr_all_organization_units haou,
2578: per_assignment_extra_info paei,
2579: per_all_assignments_f paaf,

Line 2576: hr_lookups hl2,

2572: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2574: from hr_lookups hl,
2575: hr_lookups hl1,
2576: hr_lookups hl2,
2577: hr_all_organization_units haou,
2578: per_assignment_extra_info paei,
2579: per_all_assignments_f paaf,
2580: per_all_people_f papf

Line 2668: from hr_lookups hl

2664: 0 FC,
2665: 0 FI,
2666: 0 FW,
2667: 0 total
2668: from hr_lookups hl
2669: , hr_all_organization_units haou
2670: where not exists
2671: (
2672: select 'X'

Line 2725: from hr_lookups hl

2721: 0 FC,
2722: 0 FI,
2723: 0 FW,
2724: 0 total
2725: from hr_lookups hl
2726: , hr_all_organization_units haou
2727: where not exists
2728: (
2729: select 'X'

Line 2824: from hr_lookups hl,

2820: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
2821: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2822: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2823: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2824: from hr_lookups hl,
2825: hr_lookups hl1,
2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,

Line 2825: hr_lookups hl1,

2821: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
2822: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2823: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2824: from hr_lookups hl,
2825: hr_lookups hl1,
2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,
2829: per_all_assignments_f paaf,

Line 2826: hr_lookups hl2,

2822: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
2823: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
2824: from hr_lookups hl,
2825: hr_lookups hl1,
2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,
2829: per_all_assignments_f paaf,
2830: per_periods_of_service ppos,

Line 2921: from hr_lookups hl

2917: 0 FC,
2918: 0 FI,
2919: 0 FW,
2920: 0 total
2921: from hr_lookups hl
2922: , hr_all_organization_units haou
2923: where not exists
2924: (
2925: select 'X'

Line 2978: from hr_lookups hl

2974: 0 FC,
2975: 0 FI,
2976: 0 FW,
2977: 0 total
2978: from hr_lookups hl
2979: , hr_all_organization_units haou
2980: where not exists
2981: (
2982: select 'X'

Line 3054: from hr_lookups hl,

3050: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
3051: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3052: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3053: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3054: from hr_lookups hl,
3055: hr_lookups hl1,
3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,

Line 3055: hr_lookups hl1,

3051: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3052: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3053: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3054: from hr_lookups hl,
3055: hr_lookups hl1,
3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,
3059: per_all_assignments_f paaf,

Line 3056: hr_lookups hl2,

3052: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3053: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3054: from hr_lookups hl,
3055: hr_lookups hl1,
3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,
3059: per_all_assignments_f paaf,
3060: per_periods_of_service ppos,

Line 3154: from hr_lookups hl

3150: 0 FC,
3151: 0 FI,
3152: 0 FW,
3153: 0 total
3154: from hr_lookups hl
3155: , hr_all_organization_units haou
3156: where not exists
3157: (
3158: select 'X'

Line 3211: from hr_lookups hl

3207: 0 FC,
3208: 0 FI,
3209: 0 FW,
3210: 0 total
3211: from hr_lookups hl
3212: , hr_all_organization_units haou
3213: where not exists
3214: (
3215: select 'X'

Line 3309: from hr_lookups hl,

3305: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
3306: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3307: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3308: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3309: from hr_lookups hl,
3310: hr_lookups hl1,
3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,

Line 3310: hr_lookups hl1,

3306: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3307: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3308: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3309: from hr_lookups hl,
3310: hr_lookups hl1,
3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,
3314: per_all_assignments_f paaf,

Line 3311: hr_lookups hl2,

3307: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3308: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3309: from hr_lookups hl,
3310: hr_lookups hl1,
3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,
3314: per_all_assignments_f paaf,
3315: per_periods_of_service ppos,

Line 3407: from hr_lookups hl

3403: 0 FC,
3404: 0 FI,
3405: 0 FW,
3406: 0 total
3407: from hr_lookups hl
3408: , hr_all_organization_units haou
3409: where not exists
3410: (
3411: select 'X'

Line 3463: from hr_lookups hl

3459: 0 FC,
3460: 0 FI,
3461: 0 FW,
3462: 0 total
3463: from hr_lookups hl
3464: , hr_all_organization_units haou
3465: where not exists
3466: (
3467: select 'X'

Line 3575: from hr_lookups hl,

3571: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
3572: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3574: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3575: from hr_lookups hl,
3576: hr_lookups hl1,
3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,

Line 3576: hr_lookups hl1,

3572: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
3573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3574: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3575: from hr_lookups hl,
3576: hr_lookups hl1,
3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,
3580: per_all_assignments_f paaf,

Line 3577: hr_lookups hl2,

3573: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
3574: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
3575: from hr_lookups hl,
3576: hr_lookups hl1,
3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,
3580: per_all_assignments_f paaf,
3581: per_periods_of_service ppos,

Line 3857: l_name hr_lookups.meaning%type;

3853: p_position_id in per_all_assignments_f.position_id%type
3854: ) return varchar2 is
3855:
3856: l_sql varchar2(32767);
3857: l_name hr_lookups.meaning%type;
3858:
3859: begin
3860:
3861: if p_flex = 'Job' then

Line 3867: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '

3863: begin
3864:
3865: if p_job_id is not null then
3866:
3867: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
3868: || to_char(p_job_id)
3869: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3870: || ''' and hl.lookup_code = pjd.' || p_segment;
3871:

Line 3892: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '

3888: begin
3889:
3890: if p_grade_id is not null then
3891:
3892: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
3893: || to_char(p_grade_id)
3894: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3895: || ''' and hl.lookup_code = pgd.' || p_segment;
3896:

Line 3917: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '

3913: begin
3914:
3915: if p_position_id is not null then
3916:
3917: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
3918: || to_char(p_position_id)
3919: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3920: || ''' and hl.lookup_code = ppd.' || p_segment;
3921:

Line 4159: , p_occupational_level IN hr_lookups.meaning%type

4155: , p_total IN number
4156: , p_cat_index IN number
4157: , p_lev_index IN number
4158: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
4159: , p_occupational_level IN hr_lookups.meaning%type
4160: , p_occupational_category IN hr_lookups.meaning%type
4161: , p_occupational_level_id IN hr_lookups.lookup_code%type
4162: , p_occupational_category_id IN hr_lookups.lookup_code%type
4163: ) is

Line 4160: , p_occupational_category IN hr_lookups.meaning%type

4156: , p_cat_index IN number
4157: , p_lev_index IN number
4158: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
4159: , p_occupational_level IN hr_lookups.meaning%type
4160: , p_occupational_category IN hr_lookups.meaning%type
4161: , p_occupational_level_id IN hr_lookups.lookup_code%type
4162: , p_occupational_category_id IN hr_lookups.lookup_code%type
4163: ) is
4164:

Line 4161: , p_occupational_level_id IN hr_lookups.lookup_code%type

4157: , p_lev_index IN number
4158: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
4159: , p_occupational_level IN hr_lookups.meaning%type
4160: , p_occupational_category IN hr_lookups.meaning%type
4161: , p_occupational_level_id IN hr_lookups.lookup_code%type
4162: , p_occupational_category_id IN hr_lookups.lookup_code%type
4163: ) is
4164:
4165: begin

Line 4162: , p_occupational_category_id IN hr_lookups.lookup_code%type

4158: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
4159: , p_occupational_level IN hr_lookups.meaning%type
4160: , p_occupational_category IN hr_lookups.meaning%type
4161: , p_occupational_level_id IN hr_lookups.lookup_code%type
4162: , p_occupational_category_id IN hr_lookups.lookup_code%type
4163: ) is
4164:
4165: begin
4166:

Line 4264: , p_occupational_level IN hr_lookups.meaning%type

4260: -- Procedure is used to sort the employee data
4261: -- and ready to inset into global tables
4262:
4263: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
4264: , p_occupational_level IN hr_lookups.meaning%type
4265: , p_occupational_category IN hr_lookups.meaning%type
4266: , p_race IN per_all_people_f.per_information4%type
4267: , p_sex IN per_all_people_f.sex%type
4268: , p_income IN number

Line 4265: , p_occupational_category IN hr_lookups.meaning%type

4261: -- and ready to inset into global tables
4262:
4263: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
4264: , p_occupational_level IN hr_lookups.meaning%type
4265: , p_occupational_category IN hr_lookups.meaning%type
4266: , p_race IN per_all_people_f.per_information4%type
4267: , p_sex IN per_all_people_f.sex%type
4268: , p_income IN number
4269: , p_occupational_level_id IN hr_lookups.lookup_code%type

Line 4269: , p_occupational_level_id IN hr_lookups.lookup_code%type

4265: , p_occupational_category IN hr_lookups.meaning%type
4266: , p_race IN per_all_people_f.per_information4%type
4267: , p_sex IN per_all_people_f.sex%type
4268: , p_income IN number
4269: , p_occupational_level_id IN hr_lookups.lookup_code%type
4270: , p_occupational_category_id IN hr_lookups.lookup_code%type
4271: ) is
4272:
4273: l_cat_index pls_integer ;

Line 4270: , p_occupational_category_id IN hr_lookups.lookup_code%type

4266: , p_race IN per_all_people_f.per_information4%type
4267: , p_sex IN per_all_people_f.sex%type
4268: , p_income IN number
4269: , p_occupational_level_id IN hr_lookups.lookup_code%type
4270: , p_occupational_category_id IN hr_lookups.lookup_code%type
4271: ) is
4272:
4273: l_cat_index pls_integer ;
4274: l_lev_index pls_integer ;

Line 4592: hr_lookups hl_cat,

4588: paaf.pay_basis_id
4589: from per_assignment_extra_info paei,
4590: per_assignment_status_types past,
4591: per_all_assignments_f paaf,
4592: hr_lookups hl_cat,
4593: hr_lookups hl_lev,
4594: hr_lookups hl_fn
4595: where paaf.business_group_id = p_business_group_id
4596: and p_report_date between paaf.effective_start_date and paaf.effective_end_date

Line 4593: hr_lookups hl_lev,

4589: from per_assignment_extra_info paei,
4590: per_assignment_status_types past,
4591: per_all_assignments_f paaf,
4592: hr_lookups hl_cat,
4593: hr_lookups hl_lev,
4594: hr_lookups hl_fn
4595: where paaf.business_group_id = p_business_group_id
4596: and p_report_date between paaf.effective_start_date and paaf.effective_end_date
4597: and past.assignment_status_type_id = paaf.assignment_status_type_id

Line 4594: hr_lookups hl_fn

4590: per_assignment_status_types past,
4591: per_all_assignments_f paaf,
4592: hr_lookups hl_cat,
4593: hr_lookups hl_lev,
4594: hr_lookups hl_fn
4595: where paaf.business_group_id = p_business_group_id
4596: and p_report_date between paaf.effective_start_date and paaf.effective_end_date
4597: and past.assignment_status_type_id = paaf.assignment_status_type_id
4598: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 4631: hr_lookups hl_cat,

4627: per_za_employment_equity_pkg.get_occupational_category(p_report_date, paaf.assignment_id, paaf.job_id, paaf.grade_id, paaf.position_id, paaf.business_group_id) occupational_category,
4628: paaf.pay_basis_id
4629: from per_assignment_extra_info paei,
4630: per_all_assignments_f paaf,
4631: hr_lookups hl_cat,
4632: hr_lookups hl_lev,
4633: hr_lookups hl_fn
4634: where paaf.business_group_id = p_business_group_id
4635: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)

Line 4632: hr_lookups hl_lev,

4628: paaf.pay_basis_id
4629: from per_assignment_extra_info paei,
4630: per_all_assignments_f paaf,
4631: hr_lookups hl_cat,
4632: hr_lookups hl_lev,
4633: hr_lookups hl_fn
4634: where paaf.business_group_id = p_business_group_id
4635: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
4636: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)

Line 4633: hr_lookups hl_fn

4629: from per_assignment_extra_info paei,
4630: per_all_assignments_f paaf,
4631: hr_lookups hl_cat,
4632: hr_lookups hl_lev,
4633: hr_lookups hl_fn
4634: where paaf.business_group_id = p_business_group_id
4635: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
4636: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)
4637: from per_all_assignments_f paaf1,

Line 5356: from hr_lookups hl

5352: 0 FC,
5353: 0 FI,
5354: 0 FW,
5355: 0 total
5356: from hr_lookups hl
5357: , hr_all_organization_units haou
5358: where not exists
5359: (
5360: select 'X'

Line 5411: from hr_lookups hl

5407: 0 FC,
5408: 0 FI,
5409: 0 FW,
5410: 0 total
5411: from hr_lookups hl
5412: , hr_all_organization_units haou
5413: where not exists
5414: (
5415: select 'X'

Line 5466: from hr_lookups hl

5462: 0 FC,
5463: 0 FI,
5464: 0 FW,
5465: 0 total
5466: from hr_lookups hl
5467: , hr_all_organization_units haou
5468: where not exists
5469: (
5470: select 'X'

Line 5521: from hr_lookups hl

5517: 0 FC,
5518: 0 FI,
5519: 0 FW,
5520: 0 total
5521: from hr_lookups hl
5522: , hr_all_organization_units haou
5523: where not exists
5524: (
5525: select 'X'

Line 5588: , p_occupational_level IN hr_lookups.meaning%type

5584: , p_total IN number
5585: , p_cat_index IN number
5586: , p_lev_index IN number
5587: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
5588: , p_occupational_level IN hr_lookups.meaning%type
5589: , p_occupational_category IN hr_lookups.meaning%type
5590: , p_occupational_level_id IN hr_lookups.lookup_code%type
5591: , p_occupational_category_id IN hr_lookups.lookup_code%type
5592: , p_table IN OUT nocopy t_E_differential

Line 5589: , p_occupational_category IN hr_lookups.meaning%type

5585: , p_cat_index IN number
5586: , p_lev_index IN number
5587: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
5588: , p_occupational_level IN hr_lookups.meaning%type
5589: , p_occupational_category IN hr_lookups.meaning%type
5590: , p_occupational_level_id IN hr_lookups.lookup_code%type
5591: , p_occupational_category_id IN hr_lookups.lookup_code%type
5592: , p_table IN OUT nocopy t_E_differential
5593: ) is

Line 5590: , p_occupational_level_id IN hr_lookups.lookup_code%type

5586: , p_lev_index IN number
5587: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
5588: , p_occupational_level IN hr_lookups.meaning%type
5589: , p_occupational_category IN hr_lookups.meaning%type
5590: , p_occupational_level_id IN hr_lookups.lookup_code%type
5591: , p_occupational_category_id IN hr_lookups.lookup_code%type
5592: , p_table IN OUT nocopy t_E_differential
5593: ) is
5594:

Line 5591: , p_occupational_category_id IN hr_lookups.lookup_code%type

5587: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
5588: , p_occupational_level IN hr_lookups.meaning%type
5589: , p_occupational_category IN hr_lookups.meaning%type
5590: , p_occupational_level_id IN hr_lookups.lookup_code%type
5591: , p_occupational_category_id IN hr_lookups.lookup_code%type
5592: , p_table IN OUT nocopy t_E_differential
5593: ) is
5594:
5595: begin

Line 5649: , p_occupational_level IN hr_lookups.meaning%type

5645: END ins_g_Enc_Diff_table;
5646:
5647:
5648: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
5649: , p_occupational_level IN hr_lookups.meaning%type
5650: , p_occupational_category IN hr_lookups.meaning%type
5651: , p_race IN per_all_people_f.per_information4%type
5652: , p_sex IN per_all_people_f.sex%type
5653: , p_income IN number

Line 5650: , p_occupational_category IN hr_lookups.meaning%type

5646:
5647:
5648: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
5649: , p_occupational_level IN hr_lookups.meaning%type
5650: , p_occupational_category IN hr_lookups.meaning%type
5651: , p_race IN per_all_people_f.per_information4%type
5652: , p_sex IN per_all_people_f.sex%type
5653: , p_income IN number
5654: , p_occupational_level_id IN hr_lookups.lookup_code%type

Line 5654: , p_occupational_level_id IN hr_lookups.lookup_code%type

5650: , p_occupational_category IN hr_lookups.meaning%type
5651: , p_race IN per_all_people_f.per_information4%type
5652: , p_sex IN per_all_people_f.sex%type
5653: , p_income IN number
5654: , p_occupational_level_id IN hr_lookups.lookup_code%type
5655: , p_occupational_category_id IN hr_lookups.lookup_code%type
5656: , p_table IN OUT nocopy t_E_differential
5657: ) is
5658:

Line 5655: , p_occupational_category_id IN hr_lookups.lookup_code%type

5651: , p_race IN per_all_people_f.per_information4%type
5652: , p_sex IN per_all_people_f.sex%type
5653: , p_income IN number
5654: , p_occupational_level_id IN hr_lookups.lookup_code%type
5655: , p_occupational_category_id IN hr_lookups.lookup_code%type
5656: , p_table IN OUT nocopy t_E_differential
5657: ) is
5658:
5659: l_cat_index pls_integer ;

Line 5989: hr_lookups hl_cat,

5985: paaf.pay_basis_id
5986: from per_assignment_extra_info paei,
5987: per_assignment_status_types past,
5988: per_all_assignments_f paaf,
5989: hr_lookups hl_cat,
5990: hr_lookups hl_lev,
5991: hr_lookups hl_fn
5992: where paaf.business_group_id = p_business_group_id
5993: and p_report_date between paaf.effective_start_date and paaf.effective_end_date

Line 5990: hr_lookups hl_lev,

5986: from per_assignment_extra_info paei,
5987: per_assignment_status_types past,
5988: per_all_assignments_f paaf,
5989: hr_lookups hl_cat,
5990: hr_lookups hl_lev,
5991: hr_lookups hl_fn
5992: where paaf.business_group_id = p_business_group_id
5993: and p_report_date between paaf.effective_start_date and paaf.effective_end_date
5994: and past.assignment_status_type_id = paaf.assignment_status_type_id

Line 5991: hr_lookups hl_fn

5987: per_assignment_status_types past,
5988: per_all_assignments_f paaf,
5989: hr_lookups hl_cat,
5990: hr_lookups hl_lev,
5991: hr_lookups hl_fn
5992: where paaf.business_group_id = p_business_group_id
5993: and p_report_date between paaf.effective_start_date and paaf.effective_end_date
5994: and past.assignment_status_type_id = paaf.assignment_status_type_id
5995: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 6028: hr_lookups hl_lev,

6024: nvl(decode(paei.aei_information11,'P','Permanent','N','Non-Permanent'), per_za_employment_equity_pkg.get_ee_employment_type_name(p_report_date, paaf.period_of_service_id)) employment_type,
6025: paaf.pay_basis_id
6026: from per_assignment_extra_info paei,
6027: per_all_assignments_f paaf,
6028: hr_lookups hl_lev,
6029: hr_lookups hl_fn
6030: where paaf.business_group_id = p_business_group_id
6031: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
6032: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)

Line 6029: hr_lookups hl_fn

6025: paaf.pay_basis_id
6026: from per_assignment_extra_info paei,
6027: per_all_assignments_f paaf,
6028: hr_lookups hl_lev,
6029: hr_lookups hl_fn
6030: where paaf.business_group_id = p_business_group_id
6031: and (add_months(p_report_date,-12)+1 <=paaf.effective_end_date and p_report_date >=paaf.effective_start_date)
6032: and paaf.effective_end_date = ( select max(paaf1.effective_end_date)
6033: from per_all_assignments_f paaf1,

Line 7008: from hr_lookups hl

7004: 0 FC,
7005: 0 FI,
7006: 0 FW,
7007: 0 total
7008: from hr_lookups hl
7009: , hr_all_organization_units haou
7010: where not exists
7011: (
7012: select 'X'

Line 7064: from hr_lookups hl

7060: 0 FC,
7061: 0 FI,
7062: 0 FW,
7063: 0 total
7064: from hr_lookups hl
7065: , hr_all_organization_units haou
7066: where not exists
7067: (
7068: select 'X'

Line 7120: from hr_lookups hl

7116: 0 FC,
7117: 0 FI,
7118: 0 FW,
7119: 0 total
7120: from hr_lookups hl
7121: , hr_all_organization_units haou
7122: where not exists
7123: (
7124: select 'X'

Line 7176: from hr_lookups hl

7172: 0 FC,
7173: 0 FI,
7174: 0 FW,
7175: 0 total
7176: from hr_lookups hl
7177: , hr_all_organization_units haou
7178: where not exists
7179: (
7180: select 'X'

Line 7458: from hr_lookups hl,

7454: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
7455: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7456: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7457: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7458: from hr_lookups hl,
7459: hr_lookups hl1,
7460: hr_lookups hl2,
7461: hr_all_organization_units haou,
7462: per_assignment_extra_info paei,

Line 7459: hr_lookups hl1,

7455: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7456: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7457: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7458: from hr_lookups hl,
7459: hr_lookups hl1,
7460: hr_lookups hl2,
7461: hr_all_organization_units haou,
7462: per_assignment_extra_info paei,
7463: per_all_assignments_f paaf,

Line 7460: hr_lookups hl2,

7456: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7457: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7458: from hr_lookups hl,
7459: hr_lookups hl1,
7460: hr_lookups hl2,
7461: hr_all_organization_units haou,
7462: per_assignment_extra_info paei,
7463: per_all_assignments_f paaf,
7464: per_all_people_f papf

Line 7543: from hr_lookups hl

7539: 0 FC,
7540: 0 FI,
7541: 0 FW,
7542: 0 total
7543: from hr_lookups hl
7544: , hr_all_organization_units haou
7545: where not exists
7546: (
7547: select 'X'

Line 7600: from hr_lookups hl

7596: 0 FC,
7597: 0 FI,
7598: 0 FW,
7599: 0 total
7600: from hr_lookups hl
7601: , hr_all_organization_units haou
7602: where not exists
7603: (
7604: select 'X'

Line 7677: from hr_lookups hl,

7673: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
7674: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7675: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7676: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7677: from hr_lookups hl,
7678: hr_lookups hl1,
7679: -- hr_lookups hl2,
7680: hr_all_organization_units haou,
7681: per_assignment_extra_info paei,

Line 7678: hr_lookups hl1,

7674: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7675: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7676: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7677: from hr_lookups hl,
7678: hr_lookups hl1,
7679: -- hr_lookups hl2,
7680: hr_all_organization_units haou,
7681: per_assignment_extra_info paei,
7682: per_all_assignments_f paaf,

Line 7679: -- hr_lookups hl2,

7675: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7676: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7677: from hr_lookups hl,
7678: hr_lookups hl1,
7679: -- hr_lookups hl2,
7680: hr_all_organization_units haou,
7681: per_assignment_extra_info paei,
7682: per_all_assignments_f paaf,
7683: per_all_people_f papf

Line 7761: from hr_lookups hl

7757: 0 FC,
7758: 0 FI,
7759: 0 FW,
7760: 0 total
7761: from hr_lookups hl
7762: , hr_all_organization_units haou
7763: where not exists
7764: (
7765: select 'X'

Line 7819: from hr_lookups hl

7815: 0 FC,
7816: 0 FI,
7817: 0 FW,
7818: 0 total
7819: from hr_lookups hl
7820: , hr_all_organization_units haou
7821: where not exists
7822: (
7823: select 'X'

Line 7914: from hr_lookups hl,

7910: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
7911: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7912: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7913: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7914: from hr_lookups hl,
7915: hr_lookups hl1,
7916: -- hr_lookups hl2,
7917: hr_all_organization_units haou,
7918: per_assignment_extra_info paei,

Line 7915: hr_lookups hl1,

7911: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
7912: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7913: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7914: from hr_lookups hl,
7915: hr_lookups hl1,
7916: -- hr_lookups hl2,
7917: hr_all_organization_units haou,
7918: per_assignment_extra_info paei,
7919: per_all_assignments_f paaf,

Line 7916: -- hr_lookups hl2,

7912: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
7913: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
7914: from hr_lookups hl,
7915: hr_lookups hl1,
7916: -- hr_lookups hl2,
7917: hr_all_organization_units haou,
7918: per_assignment_extra_info paei,
7919: per_all_assignments_f paaf,
7920: per_all_people_f papf

Line 8008: from hr_lookups hl

8004: 0 FC,
8005: 0 FI,
8006: 0 FW,
8007: 0 total
8008: from hr_lookups hl
8009: , hr_all_organization_units haou
8010: where not exists
8011: (
8012: select 'X'

Line 8065: from hr_lookups hl

8061: 0 FC,
8062: 0 FI,
8063: 0 FW,
8064: 0 total
8065: from hr_lookups hl
8066: , hr_all_organization_units haou
8067: where not exists
8068: (
8069: select 'X'

Line 8161: from hr_lookups hl,

8157: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
8158: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8159: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8160: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8161: from hr_lookups hl,
8162: hr_lookups hl1,
8163: -- hr_lookups hl2,
8164: hr_all_organization_units haou,
8165: per_assignment_extra_info paei,

Line 8162: hr_lookups hl1,

8158: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8159: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8160: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8161: from hr_lookups hl,
8162: hr_lookups hl1,
8163: -- hr_lookups hl2,
8164: hr_all_organization_units haou,
8165: per_assignment_extra_info paei,
8166: per_all_assignments_f paaf,

Line 8163: -- hr_lookups hl2,

8159: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8160: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8161: from hr_lookups hl,
8162: hr_lookups hl1,
8163: -- hr_lookups hl2,
8164: hr_all_organization_units haou,
8165: per_assignment_extra_info paei,
8166: per_all_assignments_f paaf,
8167: per_all_people_f papf

Line 8255: from hr_lookups hl

8251: 0 FC,
8252: 0 FI,
8253: 0 FW,
8254: 0 total
8255: from hr_lookups hl
8256: , hr_all_organization_units haou
8257: where not exists
8258: (
8259: select 'X'

Line 8312: from hr_lookups hl

8308: 0 FC,
8309: 0 FI,
8310: 0 FW,
8311: 0 total
8312: from hr_lookups hl
8313: , hr_all_organization_units haou
8314: where not exists
8315: (
8316: select 'X'

Line 8411: from hr_lookups hl,

8407: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
8408: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8409: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8410: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8411: from hr_lookups hl,
8412: hr_lookups hl1,
8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,

Line 8412: hr_lookups hl1,

8408: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8409: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8410: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8411: from hr_lookups hl,
8412: hr_lookups hl1,
8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,
8416: per_all_assignments_f paaf,

Line 8413: -- hr_lookups hl2,

8409: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8410: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8411: from hr_lookups hl,
8412: hr_lookups hl1,
8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,
8416: per_all_assignments_f paaf,
8417: per_periods_of_service ppos,

Line 8508: from hr_lookups hl

8504: 0 FC,
8505: 0 FI,
8506: 0 FW,
8507: 0 total
8508: from hr_lookups hl
8509: , hr_all_organization_units haou
8510: where not exists
8511: (
8512: select 'X'

Line 8565: from hr_lookups hl

8561: 0 FC,
8562: 0 FI,
8563: 0 FW,
8564: 0 total
8565: from hr_lookups hl
8566: , hr_all_organization_units haou
8567: where not exists
8568: (
8569: select 'X'

Line 8641: from hr_lookups hl,

8637: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
8638: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8639: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8640: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8641: from hr_lookups hl,
8642: hr_lookups hl1,
8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,

Line 8642: hr_lookups hl1,

8638: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8639: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8640: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8641: from hr_lookups hl,
8642: hr_lookups hl1,
8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,
8646: per_all_assignments_f paaf,

Line 8643: -- hr_lookups hl2,

8639: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8640: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8641: from hr_lookups hl,
8642: hr_lookups hl1,
8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,
8646: per_all_assignments_f paaf,
8647: per_periods_of_service ppos,

Line 8741: from hr_lookups hl

8737: 0 FC,
8738: 0 FI,
8739: 0 FW,
8740: 0 total
8741: from hr_lookups hl
8742: , hr_all_organization_units haou
8743: where not exists
8744: (
8745: select 'X'

Line 8798: from hr_lookups hl

8794: 0 FC,
8795: 0 FI,
8796: 0 FW,
8797: 0 total
8798: from hr_lookups hl
8799: , hr_all_organization_units haou
8800: where not exists
8801: (
8802: select 'X'

Line 8896: from hr_lookups hl,

8892: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
8893: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8894: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8895: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8896: from hr_lookups hl,
8897: hr_lookups hl1,
8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,

Line 8897: hr_lookups hl1,

8893: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
8894: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8895: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8896: from hr_lookups hl,
8897: hr_lookups hl1,
8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,
8901: per_all_assignments_f paaf,

Line 8898: -- hr_lookups hl2,

8894: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
8895: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
8896: from hr_lookups hl,
8897: hr_lookups hl1,
8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,
8901: per_all_assignments_f paaf,
8902: per_periods_of_service ppos,

Line 8994: from hr_lookups hl

8990: 0 FC,
8991: 0 FI,
8992: 0 FW,
8993: 0 total
8994: from hr_lookups hl
8995: , hr_all_organization_units haou
8996: where not exists
8997: (
8998: select 'X'

Line 9050: from hr_lookups hl

9046: 0 FC,
9047: 0 FI,
9048: 0 FW,
9049: 0 total
9050: from hr_lookups hl
9051: , hr_all_organization_units haou
9052: where not exists
9053: (
9054: select 'X'

Line 9165: from hr_lookups hl,

9161: sum(decode(papf.sex, 'F', decode(papf.per_information4, '02', 1,'ZA01', 1, 0), 0)) +
9162: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
9163: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
9164: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
9165: from hr_lookups hl,
9166: hr_lookups hl1,
9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,

Line 9166: hr_lookups hl1,

9162: sum(decode(papf.sex, 'F', decode(papf.per_information4, '03', 1, 0), 0)) +
9163: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
9164: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
9165: from hr_lookups hl,
9166: hr_lookups hl1,
9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,
9170: per_all_assignments_f paaf,

Line 9167: -- hr_lookups hl2,

9163: sum(decode(papf.sex, 'F', decode(papf.per_information4, '01', 1, 0), 0)) +
9164: sum(decode(papf.sex, 'F', decode(papf.per_information4, '04', 1, 0), 0)) total
9165: from hr_lookups hl,
9166: hr_lookups hl1,
9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,
9170: per_all_assignments_f paaf,
9171: per_periods_of_service ppos,