APPS.PAY_KR_YEA_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 809: from per_assignment_extra_info

805: nvl(to_number(aei_information14), 0),
806: nvl(to_number(aei_information15), 0),
807: nvl(to_number(aei_information16), 0), -- Bug 6024342
808: nvl(to_number(aei_information17), 0) -- Bug 6024342
809: from per_assignment_extra_info
810: where assignment_id = p_assignment_id
811: and information_type = 'KR_YEA_PREV_ER_INFO'
812: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
813: order by 1;

Line 921: from per_assignment_extra_info

917: aei_information28,
918: aei_information29,
919: -- Bug 3172960
920: nvl(to_number(aei_information24), 0)
921: from per_assignment_extra_info
922: where assignment_id = p_assignment_id
923: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
924: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
925:

Line 933: from per_assignment_extra_info

929: ,nvl(to_number(aei_information4), 0)
930: ,nvl(to_number(aei_information5), 0)
931: ,nvl(aei_information10,'N') -- Bug 6737106 Check Box Medical Total and Details
932: ,nvl(to_number(aei_information11), 0) -- Bug 7260606
933: from per_assignment_extra_info
934: where assignment_id = p_assignment_id
935: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
936: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
937:

Line 981: from per_assignment_extra_info

977: select nvl(sum(decode(aei_information9,'A',0,'B',0,decode(aei_information7,0,(nvl(aei_information3,0) + nvl(aei_information11,0))))),0) -- Employee Total
978: ,nvl(sum(decode(aei_information9,'A',(nvl(aei_information3,0) + nvl(aei_information11,0)))),0) -- Disabled Total
979: ,nvl(sum(decode(aei_information9,'B',(nvl(aei_information3,0) + nvl(aei_information11,0)))),0) -- Aged Total
980: ,nvl(sum(decode(aei_information9,'A',0,'B',0,decode(aei_information7,0,0,(nvl(aei_information3,0) + nvl(aei_information11,0))))),0) -- Dependent Total
981: from per_assignment_extra_info
982: where assignment_id = p_assignment_id
983: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
984: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
985: begin

Line 1084: from per_assignment_extra_info

1080: cursor csr_aei is
1081: select aei_information2,
1082: aei_information3,
1083: nvl(to_number(aei_information4), 0)
1084: from per_assignment_extra_info
1085: where assignment_id = p_assignment_id
1086: and information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
1087: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1088: begin

Line 1109: from per_assignment_extra_info

1105: is
1106: cursor csr_aei is
1107: select nvl(to_number(aei_information2), 0),
1108: nvl(to_number(aei_information3), 0)
1109: from per_assignment_extra_info
1110: where assignment_id = p_assignment_id
1111: and information_type = 'KR_YEA_FW_TAX_EXEM_INFO'
1112: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1113: begin

Line 1133: from per_assignment_extra_info

1129: is
1130: cursor csr_aei is
1131: select aei_information2,
1132: nvl(to_number(aei_information3), 0)
1133: from per_assignment_extra_info
1134: where assignment_id = p_assignment_id
1135: and information_type = 'KR_YEA_HOU_EXP_TAX_EXEM_INFO'
1136: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1137: begin

Line 1204: from per_assignment_extra_info

1200: nvl(to_number(aei_information15), 0),
1201: nvl(to_number(aei_information16), 0), -- Total Medical Expense Paid in Cards Bug 6630135
1202: nvl(to_number(aei_information17), 0), -- Medical Expense Paid in Cards For Dependents who are not eligible for Basic Exemption Bug 6630135
1203: nvl(to_number(aei_information20), 0) -- Small Business Installment Amount Bug 6895093
1204: from per_assignment_extra_info
1205: where assignment_id = p_assignment_id
1206: and information_type = 'KR_YEA_TAX_EXEM_INFO'
1207: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1208:

Line 1296: from per_assignment_extra_info

1292: select nvl(to_number(aei_information2), 0),
1293: nvl(to_number(aei_information3), 0),
1294: nvl(to_number(aei_information4), 0),
1295: nvl(to_number(aei_information5), 0)
1296: from per_assignment_extra_info
1297: where assignment_id = p_assignment_id
1298: and information_type = 'KR_YEA_TAX_BREAK_INFO'
1299: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1300: begin

Line 1336: from per_assignment_extra_info

1332: nvl(to_number(aei_information7), 0),
1333: nvl(to_number(aei_information8), 0),
1334: fnd_date.canonical_to_date(aei_information9),
1335: fnd_date.canonical_to_date(aei_information10)
1336: from per_assignment_extra_info
1337: where assignment_id = p_assignment_id
1338: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
1339: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1340: begin

Line 1379: from per_assignment_extra_info

1375: fnd_date.canonical_to_date(aei_information2),
1376: fnd_date.canonical_to_date(aei_information3),
1377: fnd_date.canonical_to_date(aei_information5),
1378: fnd_date.canonical_to_date(aei_information6)
1379: from per_assignment_extra_info
1380: where assignment_id = p_assignment_id
1381: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
1382: and p_effective_date between -- Bug 5083240: Consider end date to be last day of contract_expiry_date year
1383: fnd_date.canonical_to_date(aei_information2)

Line 1560: From per_assignment_extra_info

1556: -- Bug 3172960
1557: Cursor csr_fixed_tax_rate
1558: IS
1559: Select aei_information1
1560: From per_assignment_extra_info
1561: Where assignment_id = p_assignment_id
1562: And information_type = 'KR_YEA_FOREIGN_WORKER_TAX';
1563: begin
1564: --