APPS.PAY_KR_YEA20120101_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 297: from per_assignment_extra_info

293: to_number(aei_information10) Amt_sub_to_exem,
294: aei_information12 prev_bus_reg_num,
295: aei_information13 user_entered_flag,
296: object_version_number ovn
297: from per_assignment_extra_info
298: where assignment_id = p_assignment_id
299: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
300: and assignment_extra_info_id = p_asg_info_id
301: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line 305: from per_assignment_extra_info

301: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
302: --
303: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
304: select assignment_extra_info_id, object_version_number
305: from per_assignment_extra_info
306: where assignment_id = p_assignment_id
307: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
308: and aei_information2 = p_donated_year
309: and aei_information8 = p_donation_code

Line 574: from per_assignment_extra_info

570: to_number(aei_information9) donated_amount,
571: to_number(aei_information3) exempted_balance,
572: to_number(aei_information10) amt_sub_to_exem,
573: object_version_number ovn
574: from per_assignment_extra_info
575: where assignment_id = p_assignment_id
576: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
577: and aei_information8 = p_donation_code
578: and aei_information2 = to_char(p_effective_date, 'YYYY')

Line 664: from per_assignment_extra_info

660: is
661: --
662: cursor del_future_details is
663: select assignment_extra_info_id
664: from per_assignment_extra_info
665: where assignment_id = p_assignment_id
666: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
667: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
668: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));

Line 673: from per_assignment_extra_info

669: --
670: begin
671: for i in del_future_details loop
672: delete
673: from per_assignment_extra_info
674: where assignment_extra_info_id = i.assignment_extra_info_id;
675: end loop;
676: --
677: end;

Line 695: from per_assignment_extra_info

691: to_number(aei_information4) exempted_amt,
692: to_number(aei_information5) carry_over_amt,
693: to_number(aei_information10) amt_sub_to_exem,
694: to_number(aei_information11) obsolete_amt
695: from per_assignment_extra_info
696: where assignment_id = p_assignment_id
697: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
698: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
699: --