APPS.PQH_SS_WORKFLOW dependencies on PQH_SS_APPROVAL_HISTORY

Line 138: pqh_ss_approval_history ah

134: FROM pqh_ss_value_history
135: WHERE (step_history_id,approval_history_id) IN (
136: SELECT sh.step_history_id, ah.approval_history_id
137: FROM pqh_ss_step_history sh,
138: pqh_ss_approval_history ah
139: WHERE ah.transaction_history_id = sh.transaction_history_id
140: AND sh.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
141: AND ah.transaction_history_id = p_txnId
142: AND ah.approval_history_id = 0);

Line 2087: FROM pqh_ss_approval_history pah,

2083: -- RFC. It is used only in case of NON-AME approvals.
2084: --
2085: CURSOR cur_appr IS
2086: SELECT pth.employee_id
2087: FROM pqh_ss_approval_history pah,
2088: fnd_user pth
2089: WHERE pah.user_name = pth.user_name
2090: AND pah.transaction_history_id = p_txnId
2091: AND approval_history_id = (

Line 2093: FROM pqh_ss_approval_history pah1,

2089: WHERE pah.user_name = pth.user_name
2090: AND pah.transaction_history_id = p_txnId
2091: AND approval_history_id = (
2092: SELECT MAX(approval_history_id)
2093: FROM pqh_ss_approval_history pah1,
2094: fnd_user pth1
2095: WHERE pah1.user_name = pth1.user_name
2096: AND pah1.transaction_history_id = pah.transaction_history_id
2097: AND pth1.employee_id IN (

Line 2099: FROM pqh_ss_approval_history pah2,

2095: WHERE pah1.user_name = pth1.user_name
2096: AND pah1.transaction_history_id = pah.transaction_history_id
2097: AND pth1.employee_id IN (
2098: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
2099: FROM pqh_ss_approval_history pah2,
2100: fnd_user pth2
2101: WHERE pah2.user_name = pth2.user_name
2102: AND pah2.transaction_history_id = pah.transaction_history_id
2103: AND approval_history_id < (

Line 2105: FROM pqh_ss_approval_history

2101: WHERE pah2.user_name = pth2.user_name
2102: AND pah2.transaction_history_id = pah.transaction_history_id
2103: AND approval_history_id < (
2104: SELECT MIN(approval_history_id)
2105: FROM pqh_ss_approval_history
2106: WHERE transaction_history_id = pah.transaction_history_id
2107: AND user_name = p_userName
2108: AND approval_history_id > 0
2109: )