APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PHONES

Line 460: ,phn_h_phone_id per_phones.phone_id%type

456: ,addr_attribute18 per_addresses.addr_attribute18%type
457: ,addr_attribute19 per_addresses.addr_attribute19%type
458: ,addr_attribute20 per_addresses.addr_attribute20%type
459: ,addr_object_version_number per_addresses.object_version_number%type
460: ,phn_h_phone_id per_phones.phone_id%type
461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type

Line 461: ,phn_h_date_from per_phones.date_from%type

457: ,addr_attribute19 per_addresses.addr_attribute19%type
458: ,addr_attribute20 per_addresses.addr_attribute20%type
459: ,addr_object_version_number per_addresses.object_version_number%type
460: ,phn_h_phone_id per_phones.phone_id%type
461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type

Line 462: ,phn_h_date_to per_phones.date_to%type

458: ,addr_attribute20 per_addresses.addr_attribute20%type
459: ,addr_object_version_number per_addresses.object_version_number%type
460: ,phn_h_phone_id per_phones.phone_id%type
461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type

Line 463: ,phn_h_phone_number per_phones.phone_number%type

459: ,addr_object_version_number per_addresses.object_version_number%type
460: ,phn_h_phone_id per_phones.phone_id%type
461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type

Line 464: ,phn_h_object_version_number per_phones.object_version_number%type

460: ,phn_h_phone_id per_phones.phone_id%type
461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type

Line 465: ,phn_w_phone_id per_phones.phone_id%type

461: ,phn_h_date_from per_phones.date_from%type
462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type

Line 466: ,phn_w_date_from per_phones.date_from%type

462: ,phn_h_date_to per_phones.date_to%type
463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type

Line 467: ,phn_w_date_to per_phones.date_to%type

463: ,phn_h_phone_number per_phones.phone_number%type
464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type

Line 468: ,phn_w_phone_number per_phones.phone_number%type

464: ,phn_h_object_version_number per_phones.object_version_number%type
465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type

Line 469: ,phn_w_object_version_number per_phones.object_version_number%type

465: ,phn_w_phone_id per_phones.phone_id%type
466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type

Line 470: ,phn_m_phone_id per_phones.phone_id%type

466: ,phn_w_date_from per_phones.date_from%type
467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type

Line 471: ,phn_m_date_from per_phones.date_from%type

467: ,phn_w_date_to per_phones.date_to%type
468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type

Line 472: ,phn_m_date_to per_phones.date_to%type

468: ,phn_w_phone_number per_phones.phone_number%type
469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type

Line 473: ,phn_m_phone_number per_phones.phone_number%type

469: ,phn_w_object_version_number per_phones.object_version_number%type
470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type

Line 474: ,phn_m_object_version_number per_phones.object_version_number%type

470: ,phn_m_phone_id per_phones.phone_id%type
471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type

Line 475: ,phn_hf_phone_id per_phones.phone_id%type

471: ,phn_m_date_from per_phones.date_from%type
472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type

Line 476: ,phn_hf_date_from per_phones.date_from%type

472: ,phn_m_date_to per_phones.date_to%type
473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type

Line 477: ,phn_hf_date_to per_phones.date_to%type

473: ,phn_m_phone_number per_phones.phone_number%type
474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type

Line 478: ,phn_hf_phone_number per_phones.phone_number%type

474: ,phn_m_object_version_number per_phones.object_version_number%type
475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type

Line 479: ,phn_hf_object_version_number per_phones.object_version_number%type

475: ,phn_hf_phone_id per_phones.phone_id%type
476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type

Line 480: ,phn_wf_phone_id per_phones.phone_id%type

476: ,phn_hf_date_from per_phones.date_from%type
477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type
484: ,phn_wf_object_version_number per_phones.object_version_number%type

Line 481: ,phn_wf_date_from per_phones.date_from%type

477: ,phn_hf_date_to per_phones.date_to%type
478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type
484: ,phn_wf_object_version_number per_phones.object_version_number%type
485: ,pay_proposal_id per_pay_proposals.pay_proposal_id%type

Line 482: ,phn_wf_date_to per_phones.date_to%type

478: ,phn_hf_phone_number per_phones.phone_number%type
479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type
484: ,phn_wf_object_version_number per_phones.object_version_number%type
485: ,pay_proposal_id per_pay_proposals.pay_proposal_id%type
486: ,change_date per_pay_proposals.change_date%type

Line 483: ,phn_wf_phone_number per_phones.phone_number%type

479: ,phn_hf_object_version_number per_phones.object_version_number%type
480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type
484: ,phn_wf_object_version_number per_phones.object_version_number%type
485: ,pay_proposal_id per_pay_proposals.pay_proposal_id%type
486: ,change_date per_pay_proposals.change_date%type
487: ,proposed_salary_n per_pay_proposals.proposed_salary_n%type

Line 484: ,phn_wf_object_version_number per_phones.object_version_number%type

480: ,phn_wf_phone_id per_phones.phone_id%type
481: ,phn_wf_date_from per_phones.date_from%type
482: ,phn_wf_date_to per_phones.date_to%type
483: ,phn_wf_phone_number per_phones.phone_number%type
484: ,phn_wf_object_version_number per_phones.object_version_number%type
485: ,pay_proposal_id per_pay_proposals.pay_proposal_id%type
486: ,change_date per_pay_proposals.change_date%type
487: ,proposed_salary_n per_pay_proposals.proposed_salary_n%type
488: ,currency_code pay_element_types_f.input_currency_code%type