DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PKG dependencies on PAY_KR_CONT_DETAILS_V

Line 947: from pay_kr_cont_details_v pkc,

943: select sum(cei_information1),
944: sum(cei_information2),
945: sum(cei_information10),
946: sum(cei_information11)
947: from pay_kr_cont_details_v pkc,
948: per_contact_extra_info_f cei
949: where assignment_id = p_assignment_id
950: -- Bug 5879106
951: and cei.information_type(+) = 'KR_DPNT_EXPENSE_INFO'

Line 1215: from pay_kr_cont_details_v pkc,

1211: cursor csr_get_dpnt_card_expense is
1212: select nvl(sum(cei_information7),0), -- Dependent Cards(NTS) Expense
1213: nvl(sum(cei_information8),0), -- Dependent Cards(Other) Expense
1214: nvl(sum(cei_information9),0) -- Dependent Cash(NTS) Expense
1215: from pay_kr_cont_details_v pkc,
1216: per_contact_extra_info_f cei
1217: where assignment_id = p_assignment_id
1218: -- Bug 5879106
1219: and cei.information_type(+) = 'KR_DPNT_EXPENSE_INFO'