DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PAY_KR_CONT_DETAILS_V

Line 258: from pay_kr_cont_details_v pkc,

254: 'ADDTL_CHILD_FLAG=P', decode(pkc.cont_information2,'Y',decode(decode(pkc.cont_information11,'4',pay_kr_ff_functions_pkg.underaged_dpnt_flag(pkc.contact_type,pkc.national_identifier,p_effective_date),
255: pay_kr_ff_functions_pkg.addtl_child_flag(pkc.contact_type,pkc.national_identifier,p_effective_date)),'Y','1','0'),'0') addtl_child_flag,
256: /* End of Bug 6622876 */
257: '2' l_dummy
258: from pay_kr_cont_details_v pkc,
259: per_contact_extra_info_f cei -- Bug 5872042
260: where pkc.assignment_id = p_assignment_id
261: and p_effective_date between pkc.emp_start_date and pkc.emp_end_date
262: and pay_kr_ff_functions_pkg.is_exempted_dependent(pkc.contact_type, pkc.national_identifier, pkc.cont_information2,