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.PERFRPHR dependencies on HR_CONTRACT_API

Line 290: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL

286: --DECODE(con.ctr_information2,'FIXED_TERM','D','PERMANENT','I') app_contract_cat,
287: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
288: --
289: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
290: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
291: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
292: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
293: ext.rowid row_id,
294: ext.aei_information4 app_titulair,

Line 292: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,

288: --
289: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
290: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
291: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
292: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
293: ext.rowid row_id,
294: ext.aei_information4 app_titulair,
295: ext.aei_information5 app_status_before_hire,
296: ext.aei_information6 app_training_level,

Line 396: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL

392: --DECODE(con.ctr_information2,'FIXED_TERM','D','PERMANENT','I') app_contract_cat,
393: DECODE(con.ctr_information2,'FIXED_TERM','1','PERMANENT','2','NEW_HIRE_CONTRACT','4', decode(OI1.ORG_INFORMATION8, 'Y', '3')) app_contract_cat,
394: --
395: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
396: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
397: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
398: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
399: ext.rowid row_id,
400: ext.aei_information4 app_titulair,

Line 398: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,

394: --
395: TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY') proposed_end_date,
396: DECODE(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),NULL
397: ,TO_CHAR(fnd_date.canonical_to_date(con.ctr_information3),'DDMMYYYY')
398: ,TO_CHAR(hr_contract_api.get_active_end_date(con.contract_id,l_date,con.status),'DDMMYYYY')) con_end_date,
399: ext.rowid row_id,
400: ext.aei_information4 app_titulair,
401: ext.aei_information5 app_status_before_hire,
402: ext.aei_information6 app_training_level,