DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 3084: per_contact_extra_info_f cei

3080: sum(cei_information2),
3081: sum(cei_information10),
3082: sum(cei_information11)
3083: from pay_kr_cont_details_v pkc,
3084: per_contact_extra_info_f cei
3085: where assignment_id = p_assignment_id
3086: -- Bug 5879106
3087: and cei.information_type(+) = 'KR_DPNT_EXPENSE_INFO'
3088: and cei.contact_relationship_id(+) = pkc.contact_relationship_id

Line 3534: per_contact_extra_info_f cei

3530: nvl(sum(cei_information22),0), -- BUG 14219478 : Traditional Market Dpnt Direct Payment(Others)
3531: nvl(sum(cei_information23),0), -- BUG 14219478 : Dpnt Tution Paid in GIRO(NTS)
3532: nvl(sum(cei_information24),0) -- BUG 14219478 : Dpnt Tution Paid in GIRO(Others)
3533: from pay_kr_cont_details_v pkc,
3534: per_contact_extra_info_f cei
3535: where assignment_id = p_assignment_id
3536: -- Bug 5879106
3537: and cei.information_type(+) = 'KR_DPNT_EXPENSE_INFO'
3538: and cei.contact_relationship_id(+) = pkc.contact_relationship_id