eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on FND_DATE

Line 95: ,fnd_date.canonical_to_date(GET_PARAMETER(legislative_parameters,'DATE'))

91: get_parameter(legislative_parameters,'NAME_SP') name_sp,
92: TO_NUMBER ( GET_PARAMETER(legislative_parameters,'LE_ID') ) Legal
93: ,get_parameter(legislative_parameters,'VERSION') VERSION
94: ,GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
95: ,fnd_date.canonical_to_date(GET_PARAMETER(legislative_parameters,'DATE'))
96: ,business_group_id BG_ID FROM pay_payroll_actions
97: WHERE payroll_action_id = p_payroll_action_id;
98:
99: lr_parameter_info csr_parameter_info%ROWTYPE;

Line 139: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date

135: (p_payroll_action_id IN NUMBER) IS
136: SELECT business_group_id
137: ,legislative_parameters
138: ,get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
139: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date
140: FROM pay_payroll_actions
141: WHERE payroll_action_id = p_payroll_action_id;
142: --
143: l_parameter_rec csr_parameters%ROWTYPE;

Line 265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

261: );
262:
263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/
268:
269: IF g_archive = 'Y'

Line 296: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),

292: p_action_information1=> 'PYNOSSTA',
293: p_action_information2=> to_char(g_business_group_id),
294: p_action_information3=> to_char(g_legal_employer_id),
295: p_action_information4=> l_legal_employer_rec.name,
296: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),
297: p_action_information6=> g_version,
298: p_action_information7=> g_sp_org_id,
299: p_action_information8=> l_org_details_rec.name,
300: p_action_information9=> NULL,

Line 1101: SELECT fnd_date.canonical_to_date(action_information5) report_date,

1097:
1098:
1099: CURSOR csr_version (p_payroll_action_id NUMBER)
1100: IS
1101: SELECT fnd_date.canonical_to_date(action_information5) report_date,
1102: action_information6 version,
1103: nvl(action_information8,action_information4) name_sp
1104: FROM pay_action_information pai
1105: WHERE pai.action_context_id = p_payroll_action_id