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_KR_HIA_PKG dependencies on FND_DATE

Line 78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,

74: ppa.report_category,
75: ppa.business_group_id,
76: ppa.effective_date,
77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = p_payroll_action_id;

Line 79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date

75: ppa.business_group_id,
76: ppa.effective_date,
77: pay_core_utils.get_parameter('BP_HI_NUMBER',ppa.legislative_parameters) bp_hi_number, --3506171
78: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)) reported_date,
79: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',ppa.legislative_parameters)),'YYYY') year_start_date
80: into g_pact
81: from pay_payroll_actions ppa
82: where ppa.payroll_action_id = p_payroll_action_id;
83: END IF;

Line 146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')

142: AND EXISTS (SELECT NULL
143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))
148: AND ppa.action_type in ('R','Q')
149: AND paa.action_status = 'C'
150: AND paa.payroll_action_id = ppa.payroll_action_id

Line 147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))

143: FROM pay_payroll_actions ppa,
144: pay_assignment_actions paa
145: WHERE ppa.effective_date BETWEEN
146: trunc(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters)), 'YYYY')
147: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',xppa.legislative_parameters))
148: AND ppa.action_type in ('R','Q')
149: AND paa.action_status = 'C'
150: AND paa.payroll_action_id = ppa.payroll_action_id
151: AND paa.source_action_id IS NULL

Line 415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);

411: -- Bug 3438946
412: pay_archive.g_context_values.value(5) := to_char(l_last_year_assignment_action);
413: --
414: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
415: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
416: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
417: pay_archive.g_context_values.value(7) := to_char(l_establishment_id); -- 3506171
418: pay_archive.g_context_values.sz := 7;
419:

Line 602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));

598: l_count := l_count + 1;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
605: END IF;
606: END LOOP;