APPS.PAY_KR_YEA20100101_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 265: from per_assignment_extra_info

261: to_number(aei_information9) Donated_Amount,
262: to_number(aei_information3) Exempted_Balance,
263: to_number(aei_information10) Amt_sub_to_exem,
264: object_version_number ovn
265: from per_assignment_extra_info
266: where assignment_id = p_assignment_id
267: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
268: and assignment_extra_info_id = p_asg_info_id
269: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line 273: from per_assignment_extra_info

269: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
270: --
271: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
272: select assignment_extra_info_id, object_version_number
273: from per_assignment_extra_info
274: where assignment_id = p_assignment_id
275: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
276: and aei_information2 = p_donated_year
277: and aei_information8 = p_donation_code

Line 530: from per_assignment_extra_info

526: to_number(aei_information9) donated_amount,
527: to_number(aei_information3) exempted_balance,
528: to_number(aei_information10) amt_sub_to_exem,
529: object_version_number ovn
530: from per_assignment_extra_info
531: where assignment_id = p_assignment_id
532: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
533: and aei_information8 = p_donation_code
534: and aei_information2 = to_char(p_effective_date, 'YYYY')

Line 620: from per_assignment_extra_info

616: is
617: --
618: cursor del_future_details is
619: select assignment_extra_info_id
620: from per_assignment_extra_info
621: where assignment_id = p_assignment_id
622: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
623: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
624: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));

Line 629: from per_assignment_extra_info

625: --
626: begin
627: for i in del_future_details loop
628: delete
629: from per_assignment_extra_info
630: where assignment_extra_info_id = i.assignment_extra_info_id;
631: end loop;
632: --
633: end;

Line 651: from per_assignment_extra_info

647: to_number(aei_information4) exempted_amt,
648: to_number(aei_information5) carry_over_amt,
649: to_number(aei_information10) amt_sub_to_exem,
650: to_number(aei_information11) obsolete_amt
651: from per_assignment_extra_info
652: where assignment_id = p_assignment_id
653: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
654: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
655: --