APPS.HXC_RPT_TC_AUDIT_TRAIL dependencies on FND_DATE

Line 97: lp_from_date := to_char(fnd_date.canonical_to_date(p_from_date),'dd-MON-yyyy');

93: THEN
94: hr_utility.trace('translate_parameters');
95: END IF;
96:
97: lp_from_date := to_char(fnd_date.canonical_to_date(p_from_date),'dd-MON-yyyy');
98: lp_to_date := to_char(fnd_date.canonical_to_date(p_to_date),'dd-MON-yyyy');
99:
100: IF p_record_save = 'Y'
101: THEN

Line 98: lp_to_date := to_char(fnd_date.canonical_to_date(p_to_date),'dd-MON-yyyy');

94: hr_utility.trace('translate_parameters');
95: END IF;
96:
97: lp_from_date := to_char(fnd_date.canonical_to_date(p_from_date),'dd-MON-yyyy');
98: lp_to_date := to_char(fnd_date.canonical_to_date(p_to_date),'dd-MON-yyyy');
99:
100: IF p_record_save = 'Y'
101: THEN
102: lp_record_save := 'Yes';

Line 141: AND fnd_date.canonical_TO_DATE(p_from_date) BETWEEN effective_start_date

137: SELECT payroll_name
138: INTO lp_payroll
139: FROM pay_all_payrolls_f
140: WHERE payroll_id = p_payroll_id
141: AND fnd_date.canonical_TO_DATE(p_from_date) BETWEEN effective_start_date
142: AND effective_END_date;
143:
144: END IF;
145: