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_APPROVAL_SS dependencies on PQH_SS_APPROVAL_HISTORY

Line 3195: FROM pqh_ss_approval_history pah,

3191: -- RFC. It is used only in case of NON-AME approvals.
3192: --
3193: CURSOR cur_appr IS
3194: SELECT pth.employee_id
3195: FROM pqh_ss_approval_history pah,
3196: fnd_user pth
3197: WHERE pah.user_name = pth.user_name
3198: AND pah.transaction_history_id = p_transaction_id
3199: AND approval_history_id = (

Line 3201: FROM pqh_ss_approval_history pah1,

3197: WHERE pah.user_name = pth.user_name
3198: AND pah.transaction_history_id = p_transaction_id
3199: AND approval_history_id = (
3200: SELECT MAX(approval_history_id)
3201: FROM pqh_ss_approval_history pah1,
3202: fnd_user pth1
3203: WHERE pah1.user_name = pth1.user_name
3204: AND pah1.transaction_history_id = pah.transaction_history_id
3205: AND pth1.employee_id IN (

Line 3207: FROM pqh_ss_approval_history pah2,

3203: WHERE pah1.user_name = pth1.user_name
3204: AND pah1.transaction_history_id = pah.transaction_history_id
3205: AND pth1.employee_id IN (
3206: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
3207: FROM pqh_ss_approval_history pah2,
3208: fnd_user pth2
3209: WHERE pah2.user_name = pth2.user_name
3210: AND pah2.transaction_history_id = pah.transaction_history_id
3211: AND approval_history_id < (

Line 3213: FROM pqh_ss_approval_history

3209: WHERE pah2.user_name = pth2.user_name
3210: AND pah2.transaction_history_id = pah.transaction_history_id
3211: AND approval_history_id < (
3212: SELECT MIN(approval_history_id)
3213: FROM pqh_ss_approval_history
3214: WHERE transaction_history_id = pah.transaction_history_id
3215: AND user_name = lv_role_name
3216: AND approval_history_id > 0
3217: )

Line 3392: FROM pqh_ss_approval_history pah,

3388:
3389: begin
3390: select employee_id into lv_role_orig_sys_id from (
3391: SELECT pth.employee_id
3392: FROM pqh_ss_approval_history pah,
3393: fnd_user pth
3394: WHERE pah.user_name = pth.user_name
3395: AND pah.transaction_history_id = p_transaction_id
3396: and approval_history_id > 0

Line 3397: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id)

3393: fnd_user pth
3394: WHERE pah.user_name = pth.user_name
3395: AND pah.transaction_history_id = p_transaction_id
3396: and approval_history_id > 0
3397: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id)
3398: and pah.last_update_date <(select min(last_update_date) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id
3399: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id))
3400: order by pah.last_update_date desc
3401: )

Line 3398: and pah.last_update_date <(select min(last_update_date) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id

3394: WHERE pah.user_name = pth.user_name
3395: AND pah.transaction_history_id = p_transaction_id
3396: and approval_history_id > 0
3397: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id)
3398: and pah.last_update_date <(select min(last_update_date) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id
3399: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id))
3400: order by pah.last_update_date desc
3401: )
3402: where rownum = 1;

Line 3399: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id))

3395: AND pah.transaction_history_id = p_transaction_id
3396: and approval_history_id > 0
3397: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id)
3398: and pah.last_update_date <(select min(last_update_date) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id
3399: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id))
3400: order by pah.last_update_date desc
3401: )
3402: where rownum = 1;
3403: exception