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_YEA_DON_EFILE_PKG dependencies on FND_DATE

Line 111: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),

107: 'PAYROLL_ACTION_ID=C', to_char(ppa.payroll_action_id),
108: 'ASSIGN_ID=C', to_char(paa.assignment_id),
109: 'ASSIGN_ID=P', to_char(paa.assignment_id),
110: 'ASSIGNMENT_ACTION_ID=C', to_char(paa.assignment_action_id),
111: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
112: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date)
113: from per_assignments_f pa,
114: pay_assignment_actions paa,
115: pay_payroll_actions ppa,

Line 112: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date)

108: 'ASSIGN_ID=C', to_char(paa.assignment_id),
109: 'ASSIGN_ID=P', to_char(paa.assignment_id),
110: 'ASSIGNMENT_ACTION_ID=C', to_char(paa.assignment_action_id),
111: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
112: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date)
113: from per_assignments_f pa,
114: pay_assignment_actions paa,
115: pay_payroll_actions ppa,
116: hr_organization_units bp,

Line 156: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year)

152: from per_assignment_extra_info pae
153: where pae.assignment_id = pa.assignment_id
154: and pae.information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
155: and pae.aei_information2 <= g_target_year
156: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year)
157: order by 8;
158:
159:
160: cursor csr_c(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID'),p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is

Line 160: cursor csr_c(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID'),p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is

156: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year)
157: order by 8;
158:
159:
160: cursor csr_c(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID'),p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
161: select
162: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
163: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),
164: 'K', '1',

Line 188: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year

184: between pp.effective_start_date and pp.effective_end_date
185: and pae.assignment_id = pa.assignment_id
186: and pae.information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
187: and pae.aei_information2 <= g_target_year
188: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
189: order by 2,8,10;
190:
191:
192: cursor csr_d(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID')) is

Line 208: and fnd_date.canonical_to_date(pae.aei_information1)

204: per_assignments_f pa,
205: per_kr_resident_reg_number_v resreg,
206: per_assignment_extra_info pae
207: where pa.assignment_id = p_asg_id
208: and fnd_date.canonical_to_date(pae.aei_information1)
209: between pa.effective_start_date and pa.effective_end_date
210: and fnd_date.canonical_to_date(pae.aei_information1)
211: between pp.effective_start_date and pp.effective_end_date
212: and pa.person_id = resreg.person_id

Line 210: and fnd_date.canonical_to_date(pae.aei_information1)

206: per_assignment_extra_info pae
207: where pa.assignment_id = p_asg_id
208: and fnd_date.canonical_to_date(pae.aei_information1)
209: between pa.effective_start_date and pa.effective_end_date
210: and fnd_date.canonical_to_date(pae.aei_information1)
211: between pp.effective_start_date and pp.effective_end_date
212: and pa.person_id = resreg.person_id
213: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.cont_effective_start_date
214: AND resreg.cont_effective_end_date

Line 213: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.cont_effective_start_date

209: between pa.effective_start_date and pa.effective_end_date
210: and fnd_date.canonical_to_date(pae.aei_information1)
211: between pp.effective_start_date and pp.effective_end_date
212: and pa.person_id = resreg.person_id
213: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.cont_effective_start_date
214: AND resreg.cont_effective_end_date
215: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.person_effective_start_date
216: AND resreg.person_effective_end_date
217: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(pae.aei_information1))

Line 215: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.person_effective_start_date

211: between pp.effective_start_date and pp.effective_end_date
212: and pa.person_id = resreg.person_id
213: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.cont_effective_start_date
214: AND resreg.cont_effective_end_date
215: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.person_effective_start_date
216: AND resreg.person_effective_end_date
217: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(pae.aei_information1))
218: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(pae.aei_information1),
219: decode(resreg.relationship_end_reason,'D',

Line 217: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(pae.aei_information1))

213: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.cont_effective_start_date
214: AND resreg.cont_effective_end_date
215: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.person_effective_start_date
216: AND resreg.person_effective_end_date
217: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(pae.aei_information1))
218: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(pae.aei_information1),
219: decode(resreg.relationship_end_reason,'D',
220: TRUNC(add_months(resreg.relationship_end_date,12),'YYYY') -1,resreg.relationship_end_date))
221: and resreg.cont_person_id = pp.person_id

Line 218: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(pae.aei_information1),

214: AND resreg.cont_effective_end_date
215: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN resreg.person_effective_start_date
216: AND resreg.person_effective_end_date
217: and fnd_date.canonical_to_date(pae.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(pae.aei_information1))
218: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(pae.aei_information1),
219: decode(resreg.relationship_end_reason,'D',
220: TRUNC(add_months(resreg.relationship_end_date,12),'YYYY') -1,resreg.relationship_end_date))
221: and resreg.cont_person_id = pp.person_id
222: and pp.national_identifier = pae.aei_information13

Line 225: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year

221: and resreg.cont_person_id = pp.person_id
222: and pp.national_identifier = pae.aei_information13
223: and pae.assignment_id = pa.assignment_id
224: and pae.information_type = 'KR_YEA_DETAIL_DONATION_INFO'
225: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
226: group by pae.assignment_id,
227: pae.aei_information13,
228: pp.last_name || pp.first_name,
229: pae.aei_information12,