APPS.PQH_RANKING dependencies on PQH_RANK_PROCESS_APPROVALS

Line 77: From pqh_rank_process_approvals

73: p_population_count in number) IS
74:
75: Cursor csr_ranks is
76: Select rank_process_approval_id,object_version_number
77: From pqh_rank_process_approvals
78: Where rank_process_id = p_rank_process_id;
79: --
80: l_rank_process_approval_id number;
81: l_ovn number;

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 1064: INSERT into pqh_rank_process_approvals (

1060: --
1061: FOR rec_rnk in csr_rnk
1062: LOOP
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

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,