DBA Data[Home] [Help]

APPS.PAY_NO_ABS_VALIDATION dependencies on PER_CONTACT_EXTRA_INFO_F

Line 561: FROM per_contact_extra_info_f pceif

557: SELECT pceif.effective_start_date
558: ,pceif.effective_end_date
559: ,fnd_date.canonical_to_date(pceif.cei_information1) start_date
560: ,fnd_date.canonical_to_date(pceif.cei_information2) end_date
561: FROM per_contact_extra_info_f pceif
562: WHERE pceif.contact_relationship_id = p_con_relationship_id
563: AND pceif.information_type = 'NO_CMS_DIS_DATE';
564:
565: CURSOR csr_get_glb_value(p_global_name VARCHAR2, p_effective_date DATE) IS