DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 3684: from per_contact_extra_info_f

3680: select 'Y'
3681: from dual
3682: where exists(
3683: select null
3684: from per_contact_extra_info_f
3685: where contact_extra_info_id = p_contact_extra_info_id
3686: and effective_start_date = p_effective_end_date + 1);
3687: --
3688: begin

Line 3815: from per_contact_extra_info_f pcei

3811: pcei.cei_information27,
3812: pcei.cei_information28,
3813: pcei.cei_information29,
3814: pcei.cei_information30
3815: from per_contact_extra_info_f pcei
3816: where pcei.contact_relationship_id = p_contact_relationship_id
3817: and pcei.cei_information_category = p_information_type
3818: and p_effective_date
3819: between pcei.effective_start_date and pcei.effective_end_date;