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

2060: -- RFC. It is used only in case of NON-AME approvals.
2061: --
2062: CURSOR cur_appr IS
2063: SELECT pth.employee_id
2064: FROM pqh_ss_approval_history pah,
2065: fnd_user pth
2066: WHERE pah.user_name = pth.user_name
2067: AND pah.transaction_history_id = p_txnId
2068: AND approval_history_id = (

Line 2070: FROM pqh_ss_approval_history pah1,

2066: WHERE pah.user_name = pth.user_name
2067: AND pah.transaction_history_id = p_txnId
2068: AND approval_history_id = (
2069: SELECT MAX(approval_history_id)
2070: FROM pqh_ss_approval_history pah1,
2071: fnd_user pth1
2072: WHERE pah1.user_name = pth1.user_name
2073: AND pah1.transaction_history_id = pah.transaction_history_id
2074: AND pth1.employee_id IN (

Line 2076: FROM pqh_ss_approval_history pah2,

2072: WHERE pah1.user_name = pth1.user_name
2073: AND pah1.transaction_history_id = pah.transaction_history_id
2074: AND pth1.employee_id IN (
2075: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
2076: FROM pqh_ss_approval_history pah2,
2077: fnd_user pth2
2078: WHERE pah2.user_name = pth2.user_name
2079: AND pah2.transaction_history_id = pah.transaction_history_id
2080: AND approval_history_id < (

Line 2082: FROM pqh_ss_approval_history

2078: WHERE pah2.user_name = pth2.user_name
2079: AND pah2.transaction_history_id = pah.transaction_history_id
2080: AND approval_history_id < (
2081: SELECT MIN(approval_history_id)
2082: FROM pqh_ss_approval_history
2083: WHERE transaction_history_id = pah.transaction_history_id
2084: AND user_name = p_userName
2085: AND approval_history_id > 0
2086: )