APPS.PQH_PQIPED6_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 128: per_all_assignments_f ass,

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,
132: per_pay_bases ppb,

Line 182: per_all_assignments_f ass,

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,
186: per_pay_bases ppb,