DBA Data[Home] [Help]

APPS.PQH_PQIPED6_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 160: per_all_assignments_f ass,

156: COUNT(decode(pqh_nr_alien_pkg.get_count_nr_alien(peo.person_id, p_report_date), NULL, (decode(peo.per_information1, '13', decode(peo.sex, 'F', 1, NULL), NULL)))) tmrwmen
157: Commented for bug #11736960 ends */
158: --
159: FROM per_all_people_f peo,
160: per_all_assignments_f ass,
161: per_assignment_status_types ast,
162: per_jobs job,
163: per_pay_proposals ppp,
164: per_pay_bases ppb,

Line 216: per_all_assignments_f ass,

212: COUNT(decode(pei.pei_information5, '1', decode(peo.sex, 'F', 1, NULL), NULL)) wnhwmen,
213: COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'M', 1, NULL), NULL)) urmen,
214: COUNT(decode(pei.pei_information5, NULL, decode(peo.sex, 'F', 1, NULL), NULL)) urwmen
215: FROM per_all_people_f peo,
216: per_all_assignments_f ass,
217: per_assignment_status_types ast,
218: per_jobs job,
219: per_pay_proposals ppp,
220: per_pay_bases ppb,