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

Line 350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));

346: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,to_number(p_bind_variables(i).value));
347: elsif p_bind_variables(i).datatype='VARCHAR2' then
348: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,p_bind_variables(i).value);
349: elsif p_bind_variables(i).datatype='DATE' then
350: dbms_sql.bind_variable(l_cursor_id,':' || p_bind_variables(i).name,fnd_date.canonical_to_date(p_bind_variables(i).value));
351: end if;
352: END LOOP;
353: EXCEPTION
354: WHEN OTHERS THEN

Line 1088: fnd_date.canonical_to_date(term_date.screen_entry_value) PJOB_TERM_DATE,

1084: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1085: nvl(itax.screen_entry_value,0) PJOB_ITAX,
1086: nvl(si_prem.screen_entry_value,0) PJOB_SI_PREM,
1087: nvl(mutual_aid.screen_entry_value,0) PJOB_MUTUAL_AID,
1088: fnd_date.canonical_to_date(term_date.screen_entry_value) PJOB_TERM_DATE,
1089: addr.screen_entry_value PJOB_ADDR,
1090: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1091: from (select /*+ ORDERED
1092: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)

Line 1489: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),

1485: AND p_effective_date
1486: between pceif.effective_start_date and pceif.effective_end_date
1487: AND p_effective_date
1488: between DECODE(pceif.information_type,
1489: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1490: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1491: null)
1492: and nvl(DECODE(pceif.information_type,
1493: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),

Line 1490: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),

1486: between pceif.effective_start_date and pceif.effective_end_date
1487: AND p_effective_date
1488: between DECODE(pceif.information_type,
1489: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1490: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1491: null)
1492: and nvl(DECODE(pceif.information_type,
1493: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1494: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),

Line 1493: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),

1489: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1490: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1491: null)
1492: and nvl(DECODE(pceif.information_type,
1493: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1494: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),
1495: null),pceif.effective_end_date));
1496: --
1497: BEGIN

Line 1494: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),

1490: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1491: null)
1492: and nvl(DECODE(pceif.information_type,
1493: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1494: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),
1495: null),pceif.effective_end_date));
1496: --
1497: BEGIN
1498: --

Line 1583: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),

1579: between pceif.effective_start_date and pceif.effective_end_date
1580: and pceif.information_type like 'JP_HI%'
1581: and p_effective_date
1582: between decode(pceif.information_type,
1583: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1584: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1585: null)
1586: and nvl(DECODE(pceif.information_type,
1587: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),

Line 1584: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),

1580: and pceif.information_type like 'JP_HI%'
1581: and p_effective_date
1582: between decode(pceif.information_type,
1583: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1584: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1585: null)
1586: and nvl(DECODE(pceif.information_type,
1587: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1588: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),

Line 1587: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),

1583: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information3),
1584: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1585: null)
1586: and nvl(DECODE(pceif.information_type,
1587: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1588: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),
1589: null),pceif.effective_end_date));
1590: --
1591: begin

Line 1588: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),

1584: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information1),
1585: null)
1586: and nvl(DECODE(pceif.information_type,
1587: 'JP_HI_SPOUSE', fnd_date.canonical_to_date(pceif.cei_information10),
1588: 'JP_HI_DEPENDENT', fnd_date.canonical_to_date(pceif.cei_information6),
1589: null),pceif.effective_end_date));
1590: --
1591: begin
1592: --