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.HR_PERSON_DEPLOYMENT_SWI dependencies on PQH_SS_APPROVAL_HISTORY

Line 2458: from PQH_SS_APPROVAL_HISTORY

2454: else
2455: begin
2456: select ACTION
2457: into lv_action
2458: from PQH_SS_APPROVAL_HISTORY
2459: where transaction_history_id in (select hat.transaction_id
2460: from hr_api_transactions hat, hr_api_transaction_steps hats
2461: where hat.transaction_id = hats.transaction_id
2462: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2466: from PQH_SS_APPROVAL_HISTORY

2462: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2463: and hats.information1 = to_char(p_deployment_id)
2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2465: and creation_date = (select max(CREATION_DATE)
2466: from PQH_SS_APPROVAL_HISTORY
2467: where transaction_history_id in (select hat.transaction_id
2468: from hr_api_transactions hat, hr_api_transaction_steps hats
2469: where hat.transaction_id = hats.transaction_id
2470: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2522: from PQH_SS_APPROVAL_HISTORY

2518:
2519: begin
2520: select ACTION
2521: into lv_action
2522: from PQH_SS_APPROVAL_HISTORY
2523: where transaction_history_id in (select hat.transaction_id
2524: from hr_api_transactions hat, hr_api_transaction_steps hats
2525: where hat.transaction_id = hats.transaction_id
2526: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2531: from PQH_SS_APPROVAL_HISTORY

2527: and hats.information1 = to_char(p_deployment_id)
2528: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')
2529: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2530: and creation_date = (select max(CREATION_DATE)
2531: from PQH_SS_APPROVAL_HISTORY
2532: where transaction_history_id in (select hat.transaction_id
2533: from hr_api_transactions hat, hr_api_transaction_steps hats
2534: where hat.transaction_id = hats.transaction_id
2535: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2590: from PQH_SS_APPROVAL_HISTORY

2586:
2587: begin
2588: select ACTION
2589: into lv_action
2590: from PQH_SS_APPROVAL_HISTORY
2591: where transaction_history_id in (select hat.transaction_id
2592: from hr_api_transactions hat, hr_api_transaction_steps hats
2593: where hat.transaction_id = hats.transaction_id
2594: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2599: from PQH_SS_APPROVAL_HISTORY

2595: and hats.information1 = to_char(p_deployment_id)
2596: and upper(hats.information12) = 'RETURNMODE'
2597: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2598: and creation_date = (select max(CREATION_DATE)
2599: from PQH_SS_APPROVAL_HISTORY
2600: where transaction_history_id in (select hat.transaction_id
2601: from hr_api_transactions hat, hr_api_transaction_steps hats
2602: where hat.transaction_id = hats.transaction_id
2603: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'

Line 2667: from PQH_SS_APPROVAL_HISTORY

2663:
2664: begin
2665: select ACTION
2666: into lv_action
2667: from PQH_SS_APPROVAL_HISTORY
2668: where transaction_history_id = p_transaction_id
2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)

Line 2670: from PQH_SS_APPROVAL_HISTORY

2666: into lv_action
2667: from PQH_SS_APPROVAL_HISTORY
2668: where transaction_history_id = p_transaction_id
2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)