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_PQIPED7_XMLP_PKG dependencies on PQH_NR_ALIEN_PKG

Line 125: 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,

121: L_TMR_UR_WMEN NUMBER(10) := 0;
122: CURSOR GET_LINE1_COUNTS IS
123: SELECT '68' LINE,
124: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
125: 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,
126: 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,
127: 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,
128: 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,
129: 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 126: 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,

122: CURSOR GET_LINE1_COUNTS IS
123: SELECT '68' LINE,
124: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
125: 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,
126: 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,
127: 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,
128: 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,
129: 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,
130: 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 127: 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,

123: SELECT '68' LINE,
124: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
125: 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,
126: 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,
127: 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,
128: 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,
129: 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,
130: 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,
131: 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 128: 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,

124: 'FACULTY(INSTRUCTION/RESEARCH/PUBLIC SERVICE)' DISP_NAME,
125: 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,
126: 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,
127: 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,
128: 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,
129: 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,
130: 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,
131: 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,
132: 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 129: 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,

125: 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,
126: 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,
127: 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,
128: 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,
129: 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,
130: 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,
131: 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,
132: 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,
133: 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 130: 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,

126: 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,
127: 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,
128: 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,
129: 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,
130: 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,
131: 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,
132: 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,
133: 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,
134: 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 131: 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,

127: 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,
128: 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,
129: 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,
130: 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,
131: 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,
132: 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,
133: 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,
134: 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,
135: 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 132: 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,

128: 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,
129: 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,
130: 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,
131: 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,
132: 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,
133: 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,
134: 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,
135: 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,
136: 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 133: 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,

129: 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,
130: 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,
131: 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,
132: 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,
133: 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,
134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,

Line 134: 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,

130: 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,
131: 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,
132: 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,
133: 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,
134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,
138: 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)))) URWMEN

Line 135: 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,

131: 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,
132: 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,
133: 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,
134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,
138: 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)))) URWMEN
139: FROM PER_ALL_PEOPLE_F PEO,

Line 136: 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,

132: 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,
133: 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,
134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,
138: 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)))) URWMEN
139: FROM PER_ALL_PEOPLE_F PEO,
140: PER_ALL_ASSIGNMENTS_F ASS,

Line 137: 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)))) URMEN,

133: 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,
134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,
138: 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)))) URWMEN
139: FROM PER_ALL_PEOPLE_F PEO,
140: PER_ALL_ASSIGNMENTS_F ASS,
141: PER_ASSIGNMENT_STATUS_TYPES AST,

Line 138: 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)))) URWMEN

134: 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,
135: 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,
136: 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,
137: 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)))) URMEN,
138: 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)))) URWMEN
139: FROM PER_ALL_PEOPLE_F PEO,
140: PER_ALL_ASSIGNMENTS_F ASS,
141: PER_ASSIGNMENT_STATUS_TYPES AST,
142: PER_JOBS JOB,

Line 247: 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,

243: ;
244: CURSOR GET_LINE2_COUNTS IS
245: SELECT '2' LINE,
246: HL.LOOKUP_CODE JOBCODE,
247: 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,
248: 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,
249: 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,
250: 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,
251: 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 248: 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,

244: CURSOR GET_LINE2_COUNTS IS
245: SELECT '2' LINE,
246: HL.LOOKUP_CODE JOBCODE,
247: 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,
248: 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,
249: 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,
250: 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,
251: 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,
252: 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 249: 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,

245: SELECT '2' LINE,
246: HL.LOOKUP_CODE JOBCODE,
247: 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,
248: 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,
249: 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,
250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,

Line 250: 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,

246: HL.LOOKUP_CODE JOBCODE,
247: 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,
248: 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,
249: 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,
250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,

Line 251: 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,

247: 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,
248: 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,
249: 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,
250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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 252: 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,

248: 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,
249: 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,
250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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 253: 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)))) APMEN,

249: 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,
250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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 254: 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)))) APWMEN,

250: 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,
251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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,
258: 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 255: 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,

251: 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,
252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,

Line 256: 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,

252: 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,
253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,
260: 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)))) URWMEN

Line 257: 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,

253: 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)))) APMEN,
254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,
260: 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)))) URWMEN
261: FROM PER_ALL_PEOPLE_F PEO,

Line 258: 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,

254: 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)))) APWMEN,
255: 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,
256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,
260: 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)))) URWMEN
261: FROM PER_ALL_PEOPLE_F PEO,
262: PER_ALL_ASSIGNMENTS_F ASS,

Line 259: 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)))) URMEN,

255: 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,
256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,
260: 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)))) URWMEN
261: FROM PER_ALL_PEOPLE_F PEO,
262: PER_ALL_ASSIGNMENTS_F ASS,
263: PER_ASSIGNMENT_STATUS_TYPES AST,

Line 260: 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)))) URWMEN

256: 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,
257: 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,
258: 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,
259: 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)))) URMEN,
260: 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)))) URWMEN
261: FROM PER_ALL_PEOPLE_F PEO,
262: PER_ALL_ASSIGNMENTS_F ASS,
263: PER_ASSIGNMENT_STATUS_TYPES AST,
264: PER_JOBS JOB,