DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYTR_PKG dependencies on PAY_KR_CONT_DETAILS_V

Line 233: from pay_kr_cont_details_v pkc,

229: l_asg_details csr_asg_details%rowtype;
230: --
231: cursor csr_get_dpnt_cash_exp(p_assignment_id number, p_effective_date date) is
232: select sum(nvl(to_number(cei.cei_information9),0))
233: from pay_kr_cont_details_v pkc,
234: per_contact_extra_info_f cei -- Bug 5879106
235: where pkc.assignment_id = p_assignment_id
236: and p_effective_date between emp_start_date and emp_end_date
237: and p_effective_date between cont_start_date and cont_end_date