eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_KR_EXTRA_AEI_RULES dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 27: from per_assignment_extra_info

23: select 'Y'
24: from dual
25: where not exists(
26: select null
27: from per_assignment_extra_info
28: where assignment_id = p_assignment_id
29: and assignment_extra_info_id <> p_assignment_extra_info_id
30: and information_type = p_information_type
31: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY'));

Line 106: from per_assignment_extra_info

102: l_effective_end_date date;
103: --
104: cursor csr_nts(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
105: select sum(nvl(aei_information3,0))
106: from per_assignment_extra_info
107: where assignment_id = p_assignment_id
108: and information_type = p_information_type
109: and aei_information12 = l_aei_information12
110: and aei_information13 = l_aei_information13

Line 116: from per_assignment_extra_info

112: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
113: --
114: cursor csr_oth(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
115: select sum(nvl(aei_information3,0))
116: from per_assignment_extra_info
117: where assignment_id = p_assignment_id
118: and information_type = p_information_type
119: and aei_information12 = l_aei_information12
120: and aei_information13 = l_aei_information13

Line 385: from per_assignment_extra_info

381: l_effective_end_date date;
382: --
383: cursor csr_nts(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
384: select sum(nvl(aei_information3,0))
385: from per_assignment_extra_info
386: where assignment_id = p_assignment_id_o
387: and information_type = p_information_type_o
388: and aei_information12 = l_aei_information12
389: and aei_information13 = l_aei_information13

Line 395: from per_assignment_extra_info

391: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
392: --
393: cursor csr_oth(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
394: select sum(nvl(aei_information3,0))
395: from per_assignment_extra_info
396: where assignment_id = p_assignment_id_o
397: and information_type = p_information_type_o
398: and aei_information12 = l_aei_information12
399: and aei_information13 = l_aei_information13

Line 637: from per_assignment_extra_info

633: l_year varchar2(10);
634:
635: cursor csr_unique is
636: select count(aei_information2)
637: from per_assignment_extra_info
638: where assignment_id = p_assignment_id
639: and assignment_extra_info_id <> p_assignment_extra_info_id
640: and information_type = p_information_type
641: and aei_information2 = p_aei_information2

Line 732: from per_assignment_extra_info

728: l_effective_end_date date;
729: --
730: cursor csr_nts(p_aei_information8 in varchar2, p_effective_date in date) is
731: select sum(nvl(aei_information3,0) + nvl(aei_information11,0))
732: from per_assignment_extra_info
733: where assignment_id = p_assignment_id
734: and information_type = p_information_type
735: and aei_information8 = p_aei_information8
736: and aei_information13 = '1'

Line 741: from per_assignment_extra_info

737: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
738: --
739: cursor csr_oth(p_aei_information8 in varchar2, p_effective_date in date) is
740: select sum(nvl(aei_information3,0) + nvl(aei_information11,0))
741: from per_assignment_extra_info
742: where assignment_id = p_assignment_id
743: and information_type = p_information_type
744: and aei_information8 = p_aei_information8
745: and aei_information13 <> '1'

Line 1002: from per_assignment_extra_info

998: l_effective_end_date date;
999: --
1000: cursor csr_nts(p_aei_information8 in varchar2, p_effective_date in date) is
1001: select sum(nvl(aei_information3,0))
1002: from per_assignment_extra_info
1003: where assignment_id = p_assignment_id_o
1004: and information_type = p_information_type_o
1005: and aei_information8 = p_aei_information8
1006: and aei_information13 = '1'

Line 1011: from per_assignment_extra_info

1007: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1008: --
1009: cursor csr_oth(p_aei_information8 in varchar2, p_effective_date in date) is
1010: select sum(nvl(aei_information3,0))
1011: from per_assignment_extra_info
1012: where assignment_id = p_assignment_id_o
1013: and information_type = p_information_type_o
1014: and aei_information8 = p_aei_information8
1015: and aei_information13 <> '1'

Line 1246: from per_assignment_extra_info

1242: l_year varchar2(10);
1243:
1244: cursor csr_unique is
1245: select count(aei_information2)
1246: from per_assignment_extra_info
1247: where assignment_id = p_assignment_id
1248: and assignment_extra_info_id <> p_assignment_extra_info_id
1249: and information_type = p_information_type
1250: and aei_information2 = p_aei_information2

Line 1324: from per_assignment_extra_info

1320: l_effective_end_date date;
1321: --
1322: cursor csr_nts(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1323: select sum(nvl(aei_information4,0))
1324: from per_assignment_extra_info
1325: where assignment_id = p_assignment_id
1326: and information_type = p_information_type
1327: and aei_information2 = l_aei_information2
1328: and aei_information5 = l_aei_information5

Line 1334: from per_assignment_extra_info

1330: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1331: --
1332: cursor csr_oth(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1333: select sum(nvl(aei_information4,0))
1334: from per_assignment_extra_info
1335: where assignment_id = p_assignment_id
1336: and information_type = p_information_type
1337: and aei_information2 = l_aei_information2
1338: and aei_information5 = l_aei_information5

Line 1610: from per_assignment_extra_info

1606: l_effective_end_date date;
1607: --
1608: cursor csr_nts(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1609: select sum(nvl(aei_information4,0))
1610: from per_assignment_extra_info
1611: where assignment_id = p_assignment_id_o
1612: and information_type = p_information_type_o
1613: and aei_information2 = l_aei_information2
1614: and aei_information5 = l_aei_information5

Line 1620: from per_assignment_extra_info

1616: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1617: --
1618: cursor csr_oth(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1619: select sum(nvl(aei_information4,0))
1620: from per_assignment_extra_info
1621: where assignment_id = p_assignment_id_o
1622: and information_type = p_information_type_o
1623: and aei_information2 = l_aei_information2
1624: and aei_information5 = l_aei_information5

Line 1907: from per_assignment_extra_info

1903: l_effective_date date;
1904:
1905: cursor csr_priority is
1906: select 'Y'
1907: from per_assignment_extra_info
1908: where
1909: assignment_id = p_assignment_id
1910: and information_type = p_information_type
1911: and aei_information6 = p_aei_information6

Line 1917: from per_assignment_extra_info

1913: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
1914:
1915: cursor csr_dup_acc_number is
1916: select 'Y'
1917: from per_assignment_extra_info
1918: where
1919: assignment_id = p_assignment_id
1920: and information_type = p_information_type
1921: and aei_information2 = p_aei_information2

Line 2022: from per_assignment_extra_info

2018:
2019: cursor csr_hou_cont_dates is
2020: select fnd_date.canonical_to_date(aei_information2) cont_start_date,
2021: fnd_date.canonical_to_date(aei_information3) cont_end_date
2022: from per_assignment_extra_info
2023: where
2024: assignment_id = p_assignment_id
2025: and information_type = p_information_type
2026: and assignment_extra_info_id <> nvl(p_assignment_extra_info_id,0)

Line 2072: from per_assignment_extra_info

2068: l_ovn number;
2069: --
2070: cursor csr_get_donation_details(p_aei_information5 in varchar2, p_effective_date in date) is
2071: select sum(nvl(aei_information3,0))
2072: from per_assignment_extra_info
2073: where assignment_id = p_assignment_id
2074: and information_type = p_information_type
2075: and aei_information5 = p_aei_information5
2076: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line 2080: from per_assignment_extra_info

2076: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2077: --
2078: cursor csr_get_donation_type_details(p_donated_year in varchar2, p_aei_information5 in varchar2, p_effective_date in date) is
2079: select assignment_extra_info_id
2080: from per_assignment_extra_info
2081: where assignment_id = p_assignment_id
2082: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2083: and aei_information2 = p_donated_year
2084: and aei_information8 = p_aei_information5

Line 2089: from per_assignment_extra_info

2085: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2086: --
2087: cursor validate_detail_rec(p_donated_year in varchar2, p_effective_date in date) is
2088: select assignment_extra_info_id
2089: from per_assignment_extra_info
2090: where assignment_id = p_assignment_id
2091: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2092: and aei_information2 = p_donated_year
2093: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2095: from per_assignment_extra_info

2091: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2092: and aei_information2 = p_donated_year
2093: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2094: and aei_information8 not in (select distinct aei_information5
2095: from per_assignment_extra_info
2096: where assignment_id = p_assignment_id
2097: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
2098: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY'));
2099: --

Line 2102: from per_assignment_extra_info

2098: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY'));
2099: --
2100: cursor csr_donations_avail(p_effective_date in date) is
2101: select distinct aei_information5
2102: from per_assignment_extra_info
2103: where assignment_id = p_assignment_id
2104: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
2105: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2106: ----------------------------------------------------------------------------------------------

Line 2216: from per_assignment_extra_info

2212: end loop;
2213: --
2214: for j in validate_detail_rec(l_donated_year,l_effective_date) loop
2215: delete
2216: from per_assignment_extra_info
2217: where assignment_extra_info_id = j.assignment_extra_info_id
2218: and aei_information2 = l_donated_year;
2219: end loop;
2220: end if;

Line 2243: from per_assignment_extra_info

2239: l_ovn number;
2240: --
2241: cursor csr_get_donation_details(p_effective_date in date) is
2242: select sum(nvl(aei_information3,0))
2243: from per_assignment_extra_info
2244: where assignment_id = p_assignment_id_o
2245: and information_type = p_information_type_o
2246: and aei_information5 = p_aei_information5_o
2247: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line 2252: from per_assignment_extra_info

2248: --
2249: cursor csr_get_donation_type_details(p_donated_year in varchar2, p_effective_date in date) is
2250: select assignment_extra_info_id,
2251: object_version_number
2252: from per_assignment_extra_info
2253: where assignment_id = p_assignment_id_o
2254: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2255: and aei_information2 = p_donated_year
2256: and aei_information8 = p_aei_information5_o

Line 2323: delete from per_assignment_extra_info

2319: p_aei_information30 => null
2320: );
2321: else
2322:
2323: delete from per_assignment_extra_info
2324: where assignment_extra_info_id = l_don_type_asg_info_id
2325: and aei_information2 = l_donated_year;
2326: end if;
2327: end if;