DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE dependencies on FND_DATE

Line 81: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('REPORTED_DATE'))

77: ,choi.org_information2 corp_number
78: ,'BP_NUMBER=P'
79: ,hoi.org_information2 bp_number
80: ,'REPORTED_DATE=P'
81: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('REPORTED_DATE'))
82: ,'CHARACTER_TYPE=P'
83: ,'101' character_type
84: ,'REPORTING_PERIOD=P'
85: ,'1' reporting_period

Line 294: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))

290: ,xpaa.assignment_id
291: ,'PREVIOUS_EMP_COUNT=P'
292: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)
293: ,'SRS_START_DATE=P'
294: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))
295: ,'SRS_END_DATE=P'
296: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))
297: -- Bug 4201616
298: ,'RUN_TYPE_NAME=P'

Line 296: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))

292: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)
293: ,'SRS_START_DATE=P'
294: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))
295: ,'SRS_END_DATE=P'
296: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))
297: -- Bug 4201616
298: ,'RUN_TYPE_NAME=P'
299: ,prt.run_type_name
300: ,'PAYROLL_EFFECTIVE_DATE=P'

Line 301: ,fnd_date.date_to_canonical(ppa.effective_date)

297: -- Bug 4201616
298: ,'RUN_TYPE_NAME=P'
299: ,prt.run_type_name
300: ,'PAYROLL_EFFECTIVE_DATE=P'
301: ,fnd_date.date_to_canonical(ppa.effective_date)
302: -- End of 4201616
303: ,fai.value
304: -- Bug 4201616
305: FROM pay_assignment_actions paa