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

Line 10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),

6: cursor csr_header(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))) is
7: select
8: 'BUSINESS_GROUP_ID=C', to_char(ppa2.business_group_id),
9: 'PAYROLL_ID=C', to_char(ppa2.payroll_id),
10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),
11: 'OVERRIDING_DD_DATE=P', fnd_date.date_to_canonical(ppa2.overriding_dd_date),
12: 'START_DATE=P', fnd_date.date_to_canonical(ppa2.start_date),
13: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa2.effective_date),
14: 'ORG_PAYMENT_METHOD_NAME=P', opmtl.org_payment_method_name,

Line 11: 'OVERRIDING_DD_DATE=P', fnd_date.date_to_canonical(ppa2.overriding_dd_date),

7: select
8: 'BUSINESS_GROUP_ID=C', to_char(ppa2.business_group_id),
9: 'PAYROLL_ID=C', to_char(ppa2.payroll_id),
10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),
11: 'OVERRIDING_DD_DATE=P', fnd_date.date_to_canonical(ppa2.overriding_dd_date),
12: 'START_DATE=P', fnd_date.date_to_canonical(ppa2.start_date),
13: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa2.effective_date),
14: 'ORG_PAYMENT_METHOD_NAME=P', opmtl.org_payment_method_name,
15: 'GIRO_COMPANY_NAME=P', opm.pmeth_information1,

Line 12: 'START_DATE=P', fnd_date.date_to_canonical(ppa2.start_date),

8: 'BUSINESS_GROUP_ID=C', to_char(ppa2.business_group_id),
9: 'PAYROLL_ID=C', to_char(ppa2.payroll_id),
10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),
11: 'OVERRIDING_DD_DATE=P', fnd_date.date_to_canonical(ppa2.overriding_dd_date),
12: 'START_DATE=P', fnd_date.date_to_canonical(ppa2.start_date),
13: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa2.effective_date),
14: 'ORG_PAYMENT_METHOD_NAME=P', opmtl.org_payment_method_name,
15: 'GIRO_COMPANY_NAME=P', opm.pmeth_information1,
16: 'GIRO_COMPANY_CODE=P', opm.pmeth_information2,

Line 13: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa2.effective_date),

9: 'PAYROLL_ID=C', to_char(ppa2.payroll_id),
10: 'DATE_EARNED=C', fnd_date.date_to_canonical(ppa2.effective_date),
11: 'OVERRIDING_DD_DATE=P', fnd_date.date_to_canonical(ppa2.overriding_dd_date),
12: 'START_DATE=P', fnd_date.date_to_canonical(ppa2.start_date),
13: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa2.effective_date),
14: 'ORG_PAYMENT_METHOD_NAME=P', opmtl.org_payment_method_name,
15: 'GIRO_COMPANY_NAME=P', opm.pmeth_information1,
16: 'GIRO_COMPANY_CODE=P', opm.pmeth_information2,
17: 'SOURCE_BANK_CODE=P', pea.segment1,

Line 55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is

51: --
52: cursor csr_data(
53: p_payroll_action_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
54: p_org_payment_method_id NUMBER DEFAULT to_number(pay_magtape_generic.get_parameter_value('ORG_PAY_METHOD_ID')),
55: p_effective_date DATE DEFAULT fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
56: select
57: 'LAST_NAME=P', pp.last_name,
58: 'FIRST_NAME=P', pp.first_name,
59: 'NATIONAL_IDENTIFIER=P', nvl(pp.national_identifier, ' '),