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 FND_DATE

Line 117: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,

113: cursor per_asg_extra_info_ovs_csr(p_assignment_id number, p_year number) is
114: select aei_information7 p_ovs_tax_paid_fc,
115: aei_information8 p_ovs_tax_paid_lc,
116: hr_general.decode_territory(aei_information2) p_ovs_country,
117: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,
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

Line 118: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,

114: select aei_information7 p_ovs_tax_paid_fc,
115: aei_information8 p_ovs_tax_paid_lc,
116: hr_general.decode_territory(aei_information2) p_ovs_country,
117: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,
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

Line 125: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

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:
127: ------------------------- FW Tax Break Cursor --------------------------
128: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
129: select aei_information1 p_immigration_purpose,

Line 130: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,

126:
127: ------------------------- FW Tax Break Cursor --------------------------
128: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
129: select aei_information1 p_immigration_purpose,
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

Line 131: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,

127: ------------------------- FW Tax Break Cursor --------------------------
128: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
129: select aei_information1 p_immigration_purpose,
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

Line 132: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,

128: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
129: select aei_information1 p_immigration_purpose,
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'

Line 133: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date

129: select aei_information1 p_immigration_purpose,
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')

Line 137: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')

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');
139:
140: ------------------------- Prev Employer Cursor --------------------------
141: cursor csr_prev_employer_info(p_assignment_id number, p_year number) is

Line 138: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');

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');
139:
140: ------------------------- Prev Employer Cursor --------------------------
141: cursor csr_prev_employer_info(p_assignment_id number, p_year number) is
142: select sum(nvl(aei_information10,0)) p_total_hi_prem,

Line 149: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

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:
151: ------------------------- Dependent Expense Information ------------------
152: -- Bug 5726158
153: cursor csr_dpnt_expense_info(p_assignment_id number, p_effective_date date) is

Line 731: ,nvl(aei_information1,fnd_date.date_to_canonical(to_date('31-12-'||to_char(p_year),'dd-mm-rrrr'))) --Effective Date

727: + nvl(aei_information22,0)
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;

Line 735: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

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:
737: cursor sp_tax_exem_info2 is
738: select nvl(aei_information2,0) --Education Exem Total2
739: ,(nvl(aei_information4,0)

Line 745: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

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:
747: cursor tax_exem_info is
748: select (nvl(aei_information10,0)
749: +nvl(aei_information7,0)

Line 755: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

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:
757: cursor csr_get_ins_bal(p_balance_name in varchar2,
758: p_dimension_name in varchar2) is
759: select defined_balance_id

Line 778: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

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:
780: -- Local Variables
781:
782: l_hi_prem_bal NUMBER;