APPS.PQH_RANKING dependencies on PQH_RANK_PROCESS_APPROVALS_S

Line 100: select pqh_rank_process_approvals_s.nextval

96: isFound := true;
97: End Loop;
98:
99: if NOT(isFound) then
100: select pqh_rank_process_approvals_s.nextval
101: into l_rank_process_approval_id from dual;
102: -- Create Ranks
103: pqh_rank_process_approval_api.create_rank_process_approval (
104: p_effective_date => sysdate

Line 1067: SELECT pqh_rank_process_approvals_s.NEXTVAL, rank_process_id, supervisor_id, system_rank,

1063: --
1064: INSERT into pqh_rank_process_approvals (
1065: rank_process_approval_id, rank_process_id, supervisor_id,system_rank,
1066: proposed_rank )
1067: SELECT pqh_rank_process_approvals_s.NEXTVAL, rank_process_id, supervisor_id, system_rank,
1068: system_rank
1069: FROM (
1070: select rp.rank_process_id, rec_rnk.supervisor_id, rownum system_rank
1071: from pqh_rank_processes rp,