DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 339: per_contact_extra_info_f cei -- Bug 5872042

335: 'SUPER_AGED_FLAG=P', decode(pkc.cont_information3,'Y',pay_kr_ff_functions_pkg.super_aged_flag(pkc.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr'))) super_aged_flag,
336: /* End of Bug 6622876 */
337: '2' l_dummy
338: from pay_kr_cont_details_v pkc,
339: per_contact_extra_info_f cei -- Bug 5872042
340: where pkc.assignment_id = p_assignment_id
341: and p_effective_date between pkc.emp_start_date and pkc.emp_end_date
342: and pay_kr_ff_functions_pkg.is_exempted_dependent(pkc.contact_type, pkc.cont_information11,pkc.national_identifier, pkc.cont_information2,
343: pkc.cont_information3,