DBA Data[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on FND_DATE

Line 72: g_psp_effort_start:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('START_DATE', param_string)));

68: SELECT request_id, legislative_parameters into g_psp_request_id, param_string from pay_payroll_actions where payroll_action_id = p_payroll_action_id;
69:
70: g_psp_template_id := psp_template_selection.get_parameter_value('TEMPLATE_ID', param_string);
71:
72: g_psp_effort_start:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('START_DATE', param_string)));
73: g_psp_effort_end:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('END_DATE', param_string)));
74:
75:
76:

Line 73: g_psp_effort_end:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('END_DATE', param_string)));

69:
70: g_psp_template_id := psp_template_selection.get_parameter_value('TEMPLATE_ID', param_string);
71:
72: g_psp_effort_start:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('START_DATE', param_string)));
73: g_psp_effort_end:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('END_DATE', param_string)));
74:
75:
76:
77: -- fnd_file.put_line(fnd_file.log, 'start date i s '||g_psp_effort_start);