APPS.PER_QH_SUMMARY_QUERY dependencies on PER_PHONES

Line 374: ,phn_h_date_from per_phones.date_from%type

370: ,addr_attribute17 per_addresses.addr_attribute17%type
371: ,addr_attribute18 per_addresses.addr_attribute18%type
372: ,addr_attribute19 per_addresses.addr_attribute19%type
373: ,addr_attribute20 per_addresses.addr_attribute20%type
374: ,phn_h_date_from per_phones.date_from%type
375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type

Line 375: ,phn_h_date_to per_phones.date_to%type

371: ,addr_attribute18 per_addresses.addr_attribute18%type
372: ,addr_attribute19 per_addresses.addr_attribute19%type
373: ,addr_attribute20 per_addresses.addr_attribute20%type
374: ,phn_h_date_from per_phones.date_from%type
375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type

Line 376: ,phn_h_phone_number per_phones.phone_number%type

372: ,addr_attribute19 per_addresses.addr_attribute19%type
373: ,addr_attribute20 per_addresses.addr_attribute20%type
374: ,phn_h_date_from per_phones.date_from%type
375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type

Line 377: ,phn_w_date_from per_phones.date_from%type

373: ,addr_attribute20 per_addresses.addr_attribute20%type
374: ,phn_h_date_from per_phones.date_from%type
375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type

Line 378: ,phn_w_date_to per_phones.date_to%type

374: ,phn_h_date_from per_phones.date_from%type
375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type

Line 379: ,phn_w_phone_number per_phones.phone_number%type

375: ,phn_h_date_to per_phones.date_to%type
376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type

Line 380: ,phn_m_date_from per_phones.date_from%type

376: ,phn_h_phone_number per_phones.phone_number%type
377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type

Line 381: ,phn_m_date_to per_phones.date_to%type

377: ,phn_w_date_from per_phones.date_from%type
378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type

Line 382: ,phn_m_phone_number per_phones.phone_number%type

378: ,phn_w_date_to per_phones.date_to%type
379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type

Line 383: ,phn_hf_date_from per_phones.date_from%type

379: ,phn_w_phone_number per_phones.phone_number%type
380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type

Line 384: ,phn_hf_date_to per_phones.date_to%type

380: ,phn_m_date_from per_phones.date_from%type
381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type
388: ,phn_wf_phone_number per_phones.phone_number%type

Line 385: ,phn_hf_phone_number per_phones.phone_number%type

381: ,phn_m_date_to per_phones.date_to%type
382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type
388: ,phn_wf_phone_number per_phones.phone_number%type
389: ,change_date per_pay_proposals.change_date%type

Line 386: ,phn_wf_date_from per_phones.date_from%type

382: ,phn_m_phone_number per_phones.phone_number%type
383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type
388: ,phn_wf_phone_number per_phones.phone_number%type
389: ,change_date per_pay_proposals.change_date%type
390: ,proposed_salary_n per_pay_proposals.proposed_salary_n%type

Line 387: ,phn_wf_date_to per_phones.date_to%type

383: ,phn_hf_date_from per_phones.date_from%type
384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type
388: ,phn_wf_phone_number per_phones.phone_number%type
389: ,change_date per_pay_proposals.change_date%type
390: ,proposed_salary_n per_pay_proposals.proposed_salary_n%type
391: ,currency_code pay_element_types_f.input_currency_code%type

Line 388: ,phn_wf_phone_number per_phones.phone_number%type

384: ,phn_hf_date_to per_phones.date_to%type
385: ,phn_hf_phone_number per_phones.phone_number%type
386: ,phn_wf_date_from per_phones.date_from%type
387: ,phn_wf_date_to per_phones.date_to%type
388: ,phn_wf_phone_number per_phones.phone_number%type
389: ,change_date per_pay_proposals.change_date%type
390: ,proposed_salary_n per_pay_proposals.proposed_salary_n%type
391: ,currency_code pay_element_types_f.input_currency_code%type
392: ,proposal_reason_meaning hr_lookups.meaning%type