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

Line 309: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,

305: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
306: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
307: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
308: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
309: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
310: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
311: business_group_id
312: from pay_payroll_actions pact
313: where payroll_action_id = pactid;

Line 310: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,

306: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
307: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
308: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
309: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
310: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
311: business_group_id
312: from pay_payroll_actions pact
313: where payroll_action_id = pactid;
314:

Line 461: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,

457: select substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'TAX_REF'),1,20) tax_ref,
458: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
459: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
460: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
461: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
462: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
463: business_group_id
464: from pay_payroll_actions pact,
465: pay_assignment_actions paa

Line 462: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,

458: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
459: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
460: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
461: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
462: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
463: business_group_id
464: from pay_payroll_actions pact,
465: pay_assignment_actions paa
466: where paa.assignment_action_id = p_assactid

Line 742: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,

738: select substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
739: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
740: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
741: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
742: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
743: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
744: business_group_id,
745: pact.effective_date,
746: pay_gb_eoy_archive.get_parameter(legislative_parameters,'REPORT_FORMAT') report_format,

Line 743: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,

739: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
740: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
741: --to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
742: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
743: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
744: business_group_id,
745: pact.effective_date,
746: pay_gb_eoy_archive.get_parameter(legislative_parameters,'REPORT_FORMAT') report_format,
747: fnd_number.number_to_canonical(pact.request_id) request_id,

Line 797: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,

793: select
794: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
795: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
796: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
797: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
798: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date
799: from pay_payroll_actions pact
800: where payroll_action_id = pactid;
801:

Line 798: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date

794: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
795: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_FROM=') + 13,10),'YYYY-MM-DD') payment_from_date,
796: -- to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'PAYMENT_TO=') + 11,10),'YYYY-MM-DD') payment_to_date,
797: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
798: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date
799: from pay_payroll_actions pact
800: where payroll_action_id = pactid;
801:
802: cursor csr_header_det(p_bus_id number,