APPS.PAY_JP_ZENGIN_TAPE dependencies on FND_DATE

Line 143: SELECT fnd_date.date_to_canonical(effective_date)

139: BEGIN
140: hr_utility.set_location('bacsmgtp.get_session_date',1);
141: -- FlexDate Change
142: -- SELECT to_char(effective_date,'DD-MON-YYYY')
143: SELECT fnd_date.date_to_canonical(effective_date)
144: INTO p_session_date
145: from fnd_sessions
146: where session_id = userenv('sessionid');
147: --

Line 162: fnd_date.date_to_canonical(add_months(sysdate,2)) ) Expiration_date

158: decode(instr(LEGISLATIVE_PARAMETERS,'EXPIRATION_DATE='),
159: '0', null,
160: instr(LEGISLATIVE_PARAMETERS,'EXPIRATION_DATE='))+16,11),
161: -- to_char(add_months(sysdate,2),'DD-MON-YYYY') ) Expiration_date
162: fnd_date.date_to_canonical(add_months(sysdate,2)) ) Expiration_date
163: into p_expiration_date
164: from pay_payroll_actions
165: where PAYROLL_ACTION_ID = p_payroll_action_id;
166: --

Line 201: substr(fnd_date.date_to_canonical(OVERRIDING_DD_DATE),1,11) effdate

197: hr_utility.trace('payroll_action_id='||p_payroll_action_id);
198: BEGIN
199: select
200: -- substr(to_char(OVERRIDING_DD_DATE ,'DD-MON-YYYY'),1,11) effdate
201: substr(fnd_date.date_to_canonical(OVERRIDING_DD_DATE),1,11) effdate
202: into p_process_date
203: from pay_payroll_actions
204: where PAYROLL_ACTION_ID = p_payroll_action_id;
205: --

Line 608: WHERE fnd_date.canonical_to_date(param1)

604: FROM hr_soft_coding_keyflex target,
605: per_assignments_f ASSIGN,
606: pay_payrolls_f PAYROLL
607: -- WHERE to_date (param1, 'DD-MON-YYYY')
608: WHERE fnd_date.canonical_to_date(param1)
609: BETWEEN ASSIGN.effective_start_date
610: AND ASSIGN.effective_end_date
611: AND ASSIGN.assignment_id = param2
612: AND target.id_flex_num = 50106

Line 615: AND fnd_date.canonical_to_date(param1)

611: AND ASSIGN.assignment_id = param2
612: AND target.id_flex_num = 50106
613: AND target.enabled_flag = 'Y'
614: AND PAYROLL.payroll_id = ASSIGN.payroll_id
615: AND fnd_date.canonical_to_date(param1)
616: BETWEEN PAYROLL.effective_start_date
617: AND PAYROLL.effective_end_date
618: AND target.soft_coding_keyflex_id =
619: PAYROLL.soft_coding_keyflex_id;