APPS.PER_ZA_EE_DIFFERENTIAL_PKG dependencies on PER_ZA_EMPLOYMENT_EQUITY

Line 22: per_za_employment_equity_pkg.init_g_cat_lev_new_table(P_REPORT_DATE,P_BUSINESS_GROUP_ID,P_LEGAL_ENTITY_ID,P_SALARY_METHOD);

18: hr_utility.set_location('P_REPORT_DATE:'||P_REPORT_DATE,10);
19: hr_utility.set_location('P_BUSINESS_GROUP_ID:'||P_BUSINESS_GROUP_ID,10);
20: hr_utility.set_location('P_LEGAL_ENTITY_ID:'||P_LEGAL_ENTITY_ID,10);
21: hr_utility.set_location('P_SALARY_METHOD:'||P_SALARY_METHOD,10);
22: per_za_employment_equity_pkg.init_g_cat_lev_new_table(P_REPORT_DATE,P_BUSINESS_GROUP_ID,P_LEGAL_ENTITY_ID,P_SALARY_METHOD);
23: return TRUE;
24: end;
25:
26: function afterreport return boolean

Line 69: from per_za_employment_equity

65: BEGIN
66: if p_report_id not in ('EDF','EDFI') then
67: select nvl(sum(decode(p_emp_type,'FA',FA,'FC',FC,'FI',FI,'FW',FW,'MA',MA,'MC',MC,'MI',MI,'MW',MW)),0)
68: into l_cnt
69: from per_za_employment_equity
70: where legal_entity_id = p_legal_entity_id
71: and report_id = p_report_id
72: and employment_type=p_employment_type;
73: elsif p_emp_type = 'FF' then

Line 76: from per_za_employment_equity

72: and employment_type=p_employment_type;
73: elsif p_emp_type = 'FF' then
74: select nvl(sum(FA)+sum(FC)+sum(FI)+sum(FW),0)
75: into l_cnt
76: from per_za_employment_equity
77: where legal_entity_id = p_legal_entity_id
78: and report_id = p_report_id
79: and employment_type=p_employment_type;
80: elsif p_emp_type = 'MF' then

Line 83: from per_za_employment_equity

79: and employment_type=p_employment_type;
80: elsif p_emp_type = 'MF' then
81: select nvl(sum(MA)+sum(MC)+sum(MI)+sum(MW),0)
82: into l_cnt
83: from per_za_employment_equity
84: where legal_entity_id = p_legal_entity_id
85: and report_id = p_report_id
86: and employment_type=p_employment_type;
87: end if;

Line 105: from per_za_employment_equity

101: if p_inc_num = 'NUM' then
102: --Calculate the count of employees
103: select nvl(SUM(TOTAL),0)
104: into l_cnt
105: from per_za_employment_equity
106: where legal_entity_id = p_legal_entity_id
107: and report_id in ('ED','EDF')
108: and employment_type=p_employment_type;
109: else

Line 113: from per_za_employment_equity

109: else
110: --Calculate the sum of employee income
111: select nvl(SUM(TOTAL),0)
112: into l_cnt
113: from per_za_employment_equity
114: where legal_entity_id = p_legal_entity_id
115: and report_id in ('EDI','EDFI')
116: and employment_type=p_employment_type;
117: end if;