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.PQH_PQIPED6_XMLP_PKG dependencies on PQH_NR_ALIEN_PKG

Line 113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,

109: SELECT 1 line,
110: hl.lookup_code job_category_name,
111: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
112: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,

Line 114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,

110: hl.lookup_code job_category_name,
111: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
112: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,

Line 115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,

111: pqh_salary_class_intervals_pkg.get_job_sal_interval(pqh_employment_category.identify_empl_category(ass.employment_category,
112: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,

Line 116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,

112: cp_fr, cp_ft, cp_pr, cp_pt), hl.lookup_code, nvl(ppp.proposed_salary_n, 0) * ppb.pay_annualization_factor) salary_range,
113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,

Line 117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,

113: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'M', 1, NULL), NULL)) nrmen,
114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,

Line 118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,

114: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), '1', decode(peo.sex, 'F', 1, NULL), NULL)) nrwmen,
115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,

Line 119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,

115: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'M', 1, NULL), NULL)))) bnhmen,
116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,

Line 120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,

116: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '2', decode(peo.sex, 'F', 1, NULL), NULL)))) bnhwmen,
117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,

Line 121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,

117: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'M', 1, NULL), NULL)))) am_almen,
118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,

Line 122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,

118: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '6', decode(peo.sex, 'F', 1, NULL), NULL)))) am_alwmen,
119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen

Line 123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,

119: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'M', 1, NULL), '5', decode(peo.sex, 'M', 1, NULL), NULL)))) a_pmen,
120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen
127: FROM per_all_people_f peo,

Line 124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,

120: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '4', decode(peo.sex, 'F', 1, NULL), '5', decode(peo.sex, 'F', 1, NULL), NULL)))) a_pwmen,
121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen
127: FROM per_all_people_f peo,
128: per_all_assignments_f ass,

Line 125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,

121: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'M', 1, NULL), '9', decode(peo.sex, 'M', 1, NULL), NULL)))) hmen,
122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen
127: FROM per_all_people_f peo,
128: per_all_assignments_f ass,
129: per_assignment_status_types ast,

Line 126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen

122: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '3', decode(peo.sex, 'F', 1, NULL), '9', decode(peo.sex, 'F', 1, NULL), NULL)))) hwmen,
123: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'M', 1, NULL), NULL)))) wnhmen,
124: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '1', decode(peo.sex, 'F', 1, NULL), NULL)))) wnhwmen,
125: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'M', 1, NULL), NULL)), NULL)) urmen,
126: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, NULL, decode(peo.sex, 'F', 1, NULL), NULL)), NULL)) urwmen
127: FROM per_all_people_f peo,
128: per_all_assignments_f ass,
129: per_assignment_status_types ast,
130: per_jobs job,