DBA Data[Home] [Help]

APPS.PQH_CORPS_UTILITY dependencies on PQH_COPY_ENTITY_TXNS

Line 135: FROM pqh_copy_entity_txns

131: Function get_increased_index(p_gross_index IN NUMBER, p_copy_entity_txn_id IN NUMBER) RETURN NUMBER IS
132:
133: CURSOR csr_eff_date IS
134: SELECT action_date
135: FROM pqh_copy_entity_txns
136: WHERE copy_entity_txn_id = p_copy_entity_txn_id;
137: /* For Bug Fix 3532356: Retrieving the Effective Date value from pqh_copy_entity_txns.action_date
138: instead from ben_copy_entity_results.
139: */

Line 137: /* For Bug Fix 3532356: Retrieving the Effective Date value from pqh_copy_entity_txns.action_date

133: CURSOR csr_eff_date IS
134: SELECT action_date
135: FROM pqh_copy_entity_txns
136: WHERE copy_entity_txn_id = p_copy_entity_txn_id;
137: /* For Bug Fix 3532356: Retrieving the Effective Date value from pqh_copy_entity_txns.action_date
138: instead from ben_copy_entity_results.
139: */
140:
141: l_effective_date DATE;