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 4206: FROM pqh_ss_approval_history pah,

4202: -- RFC. It is used only in case of NON-AME approvals.
4203: --
4204: CURSOR cur_appr IS
4205: SELECT pth.employee_id
4206: FROM pqh_ss_approval_history pah,
4207: fnd_user pth
4208: WHERE pah.user_name = pth.user_name
4209: AND pah.transaction_history_id = p_transaction_id
4210: AND approval_history_id = (

Line 4212: FROM pqh_ss_approval_history pah1,

4208: WHERE pah.user_name = pth.user_name
4209: AND pah.transaction_history_id = p_transaction_id
4210: AND approval_history_id = (
4211: SELECT MAX(approval_history_id)
4212: FROM pqh_ss_approval_history pah1,
4213: fnd_user pth1
4214: WHERE pah1.user_name = pth1.user_name
4215: AND pah1.transaction_history_id = pah.transaction_history_id
4216: AND pth1.employee_id IN (

Line 4218: FROM pqh_ss_approval_history pah2,

4214: WHERE pah1.user_name = pth1.user_name
4215: AND pah1.transaction_history_id = pah.transaction_history_id
4216: AND pth1.employee_id IN (
4217: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
4218: FROM pqh_ss_approval_history pah2,
4219: fnd_user pth2
4220: WHERE pah2.user_name = pth2.user_name
4221: AND pah2.transaction_history_id = pah.transaction_history_id
4222: AND approval_history_id < (

Line 4224: FROM pqh_ss_approval_history

4220: WHERE pah2.user_name = pth2.user_name
4221: AND pah2.transaction_history_id = pah.transaction_history_id
4222: AND approval_history_id < (
4223: SELECT MIN(approval_history_id)
4224: FROM pqh_ss_approval_history
4225: WHERE transaction_history_id = pah.transaction_history_id
4226: AND user_name = lv_role_name
4227: AND approval_history_id > 0
4228: )

Line 4403: FROM pqh_ss_approval_history pah,

4399:
4400: begin
4401: select employee_id into lv_role_orig_sys_id from (
4402: SELECT pth.employee_id
4403: FROM pqh_ss_approval_history pah,
4404: fnd_user pth
4405: WHERE pah.user_name = pth.user_name
4406: AND pah.transaction_history_id = p_transaction_id
4407: and approval_history_id > 0

Line 4408: 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)

4404: fnd_user pth
4405: WHERE pah.user_name = pth.user_name
4406: AND pah.transaction_history_id = p_transaction_id
4407: and approval_history_id > 0
4408: 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)
4409: 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
4410: 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))
4411: order by pah.last_update_date desc
4412: )

Line 4409: 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

4405: WHERE pah.user_name = pth.user_name
4406: AND pah.transaction_history_id = p_transaction_id
4407: and approval_history_id > 0
4408: 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)
4409: 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
4410: 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))
4411: order by pah.last_update_date desc
4412: )
4413: where rownum = 1;

Line 4410: 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))

4406: AND pah.transaction_history_id = p_transaction_id
4407: and approval_history_id > 0
4408: 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)
4409: 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
4410: 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))
4411: order by pah.last_update_date desc
4412: )
4413: where rownum = 1;
4414: exception