DBA Data[Home] [Help]

APPS.PQH_PQIPED6_XMLP_PKG dependencies on PER_JOBS

Line 130: per_jobs job,

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,
133: hr_lookups hl
134: WHERE peo.person_id = ass.person_id

Line 184: per_jobs job,

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,
187: hr_lookups hl,
188: per_people_extra_info pei