APPS.PAY_KR_YEA20110101_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 277: from per_assignment_extra_info

273: to_number(aei_information10) Amt_sub_to_exem,
274: aei_information12 prev_bus_reg_num,
275: aei_information13 user_entered_flag,
276: object_version_number ovn
277: from per_assignment_extra_info
278: where assignment_id = p_assignment_id
279: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
280: and assignment_extra_info_id = p_asg_info_id
281: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line 285: from per_assignment_extra_info

281: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
282: --
283: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
284: select assignment_extra_info_id, object_version_number
285: from per_assignment_extra_info
286: where assignment_id = p_assignment_id
287: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
288: and aei_information2 = p_donated_year
289: and aei_information8 = p_donation_code

Line 549: from per_assignment_extra_info

545: to_number(aei_information9) donated_amount,
546: to_number(aei_information3) exempted_balance,
547: to_number(aei_information10) amt_sub_to_exem,
548: object_version_number ovn
549: from per_assignment_extra_info
550: where assignment_id = p_assignment_id
551: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
552: and aei_information8 = p_donation_code
553: and aei_information2 = to_char(p_effective_date, 'YYYY')

Line 639: from per_assignment_extra_info

635: is
636: --
637: cursor del_future_details is
638: select assignment_extra_info_id
639: from per_assignment_extra_info
640: where assignment_id = p_assignment_id
641: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
642: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
643: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));

Line 648: from per_assignment_extra_info

644: --
645: begin
646: for i in del_future_details loop
647: delete
648: from per_assignment_extra_info
649: where assignment_extra_info_id = i.assignment_extra_info_id;
650: end loop;
651: --
652: end;

Line 670: from per_assignment_extra_info

666: to_number(aei_information4) exempted_amt,
667: to_number(aei_information5) carry_over_amt,
668: to_number(aei_information10) amt_sub_to_exem,
669: to_number(aei_information11) obsolete_amt
670: from per_assignment_extra_info
671: where assignment_id = p_assignment_id
672: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
673: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
674: --