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.PAY_KR_PAYKRYRS_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 8: from per_assignment_extra_info

4: ------------------------- Education Exp Cursor----------------------------
5: cursor per_asg_extra_info_educ_csr(p_assignment_id number, p_year number) is
6: select aei_information3
7: ,to_number(aei_information4)
8: from per_assignment_extra_info
9: where assignment_id = p_assignment_id
10: and information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
11: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
12: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 17: from per_assignment_extra_info

13:
14: ------------------------- Housing Exp Cursor----------------------------
15: cursor per_asg_extra_info_hou_csr(p_assignment_id number, p_year number) is
16: select sum(to_number(aei_information3)) aei_information3
17: from per_assignment_extra_info
18: where assignment_id = p_assignment_id
19: and aei_information2 <> 'HST2'
20: and information_type = 'KR_YEA_HOU_EXP_TAX_EXEM_INFO'
21: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')

Line 49: from per_assignment_extra_info

45: ,aei_information27 l_marriage_count
46: ,aei_information29 l_reloc_count
47: ,aei_information28 l_funeral_count
48: ,aei_information26 l_lt_hou_int_repay_gt_15
49: from per_assignment_extra_info
50: where assignment_id = p_assignment_id
51: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
52: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
53: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 63: from per_assignment_extra_info

59: aei_information3 med_exp_card,
60: aei_information4 l_promotional_fund_don,
61: aei_information5 l_religious_don,
62: aei_information6 l_other_don
63: from per_assignment_extra_info
64: where assignment_id = p_assignment_id
65: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
66: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
67: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 86: from per_assignment_extra_info

82: ,aei_information13 cash_receipt -- Bug 4336742
83: ,aei_information2 p_other_exem_np_prem
84: ,aei_information15 p_other_exem_pen_prem -- Bug 6655323
85: ,aei_information14 corporate_pension -- Bug 4764823
86: from per_assignment_extra_info
87: where assignment_id = p_assignment_id
88: and information_type = 'KR_YEA_TAX_EXEM_INFO'
89: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
90: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 97: from per_assignment_extra_info

93: cursor per_asg_extra_info_break_csr(p_assignment_id number, p_year number) is
94: select aei_information2 hou_loan_int_repay
95: ,aei_information4 lt_stk_sav1
96: ,aei_information5 lt_stk_sav2
97: from per_assignment_extra_info
98: where assignment_id = p_assignment_id
99: and information_type = 'KR_YEA_TAX_BREAK_INFO'
100: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
101: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 106: from per_assignment_extra_info

102:
103: ------------------------- FW Info Cursor -------------------------------
104: cursor per_asg_extra_info_fw_csr(p_assignment_id number, p_year number) is
105: select nvl(aei_information2,0) + nvl(aei_information3,0)
106: from per_assignment_extra_info
107: where assignment_id = p_assignment_id
108: and information_type = 'KR_YEA_FW_TAX_EXEM_INFO'
109: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
110: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 122: from per_assignment_extra_info

118: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,
119: aei_information11 p_ovs_location,
120: aei_information12 p_ovs_period,
121: aei_information13 p_ovs_title
122: from per_assignment_extra_info
123: where assignment_id = p_assignment_id
124: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
125: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
126:

Line 134: from per_assignment_extra_info

130: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,
131: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,
132: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,
133: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
134: from per_assignment_extra_info
135: where assignment_id = p_assignment_id
136: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
137: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')
138: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');

Line 146: from per_assignment_extra_info

142: select sum(nvl(aei_information10,0)) p_total_hi_prem,
143: sum(nvl(aei_information11,0)) p_total_ei_prem,
144: sum(nvl(aei_information12,0)) p_total_np_prem,
145: sum(nvl(aei_information16,0)) p_total_pen_prem /* Bug 6655323 */
146: from per_assignment_extra_info
147: where assignment_id = p_assignment_id
148: and information_type = 'KR_YEA_PREV_ER_INFO'
149: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
150:

Line 732: from per_assignment_extra_info

728: + nvl(aei_information23,0)
729: + nvl(aei_information30,0)) --Donation Total1
730: ,nvl(aei_information19,0) --Political_donation
731: ,nvl(aei_information1,fnd_date.date_to_canonical(to_date('31-12-'||to_char(p_year),'dd-mm-rrrr'))) --Effective Date
732: from per_assignment_extra_info
733: where ASSIGNMENT_ID=p_emp_assignment_id
734: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
735: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
736:

Line 742: from per_assignment_extra_info

738: select nvl(aei_information2,0) --Education Exem Total2
739: ,(nvl(aei_information4,0)
740: +nvl(aei_information5,0)
741: +nvl(aei_information6,0)) --Donation Total2
742: from per_assignment_extra_info
743: where ASSIGNMENT_ID=p_emp_assignment_id
744: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
745: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
746:

Line 752: from per_assignment_extra_info

748: select (nvl(aei_information10,0)
749: +nvl(aei_information7,0)
750: +nvl(aei_information12,0)) --Card Total
751: ,nvl(aei_information13,0) --Cash Total
752: from per_assignment_extra_info
753: where ASSIGNMENT_ID=p_emp_assignment_id
754: and information_type = 'KR_YEA_TAX_EXEM_INFO'
755: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
756:

Line 775: from per_assignment_extra_info

771: ,aei_information3 --Education NTS
772: ,aei_information4 --Cards NTS
773: ,aei_information5 --Donation NTS
774: ,aei_information6 --Insurance NTS -- Bug 5726158
775: from per_assignment_extra_info
776: where ASSIGNMENT_ID=p_emp_assignment_id
777: and information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
778: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
779: