APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on FND_DATE

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

124: 'PAYROLL_ACTION_ID=C', to_char(ppa.payroll_action_id),
125: 'ASSIGNMENT_ID=C', to_char(paa.assignment_id),
126: 'ASSIGNMENT_ID=P', to_char(paa.assignment_id),
127: 'ASSIGNMENT_ACTION_ID=C', to_char(paa.assignment_action_id),
128: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
129: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date),
130: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
131: 'FULL_NAME=P', pp.last_name || pp.first_name,
132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),

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

125: 'ASSIGNMENT_ID=C', to_char(paa.assignment_id),
126: 'ASSIGNMENT_ID=P', to_char(paa.assignment_id),
127: 'ASSIGNMENT_ACTION_ID=C', to_char(paa.assignment_action_id),
128: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
129: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date),
130: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
131: 'FULL_NAME=P', pp.last_name || pp.first_name,
132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),

Line 132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),

128: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa.effective_date),
129: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date),
130: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
131: 'FULL_NAME=P', pp.last_name || pp.first_name,
132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
135: 'COUNTRY_CODE=P', pp.country_of_birth,
136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717

Line 133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),

129: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date),
130: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
131: 'FULL_NAME=P', pp.last_name || pp.first_name,
132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
135: 'COUNTRY_CODE=P', pp.country_of_birth,
136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717
137: from per_people_f pp,

Line 189: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = g_target_year

185: 'PREV_STCK_PUR_OPT_EXEC_EARN=P', nvl(aei.aei_information17, 0) -- Bug 6622876
186: from per_assignment_extra_info aei
187: where aei.assignment_id = p_assignment_id
188: and aei.information_type = 'KR_YEA_PREV_ER_INFO'
189: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = g_target_year
190: order by aei_information1, 2;
191: ------------------------------------------------------------------------
192:
193: -- Note: Any change in this cursor must be included in

Line 197: p_effective_date date default fnd_date.canonical_to_date(

193: -- Note: Any change in this cursor must be included in
194: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.
195:
196: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
197: p_effective_date date default fnd_date.canonical_to_date(
198: pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))
199: ) is
200: -- Bug 5654127
201: select 'CONTACT_TYPE=P', '0' contact_type,