APPS.PQH_PQIPED6_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 127: FROM per_all_people_f peo,

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,
131: per_pay_proposals ppp,

Line 181: FROM per_all_people_f peo,

177: COUNT(decode(pei.pei_information5, '1', decode(peo.sex, 'M', 1, NULL), NULL)) wnhmen,
178: COUNT(decode(pei.pei_information5, '1', decode(peo.sex, 'F', 1, NULL), NULL)) wnhwmen,
179: COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'M', 1, NULL), NULL)) urmen,
180: COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'F', 1, NULL), NULL)) urwmen
181: FROM per_all_people_f peo,
182: per_all_assignments_f ass,
183: per_assignment_status_types ast,
184: per_jobs job,
185: per_pay_proposals ppp,