DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_COPY_PROCESS dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 195: l_row_typ_cd PQH_COPY_ENTITY_ATTRIBS.ROW_TYPE_CD%TYPE;

191: --
192: l_proc VARCHAR2 (80) := g_package || '.process';
193: l_cet_object_version_number NUMBER (15);
194: l_target_typ_cd VARCHAR2(30);
195: l_row_typ_cd PQH_COPY_ENTITY_ATTRIBS.ROW_TYPE_CD%TYPE;
196: l_start_with PQH_COPY_ENTITY_TXNS.START_WITH%TYPE;
197: l_effective_date DATE;
198: l_effective_date_to_copy DATE;
199: l_exception VARCHAR2(3000);

Line 216: FROM pqh_copy_entity_txns cet, pqh_copy_entity_attribs cea

212: cea.row_type_cd,
213: cea.information3 target_typ_cd,
214: cea.information4 reuse_object_flag,
215: cea.information1 prefix_suffix_text
216: FROM pqh_copy_entity_txns cet, pqh_copy_entity_attribs cea
217: WHERE cet.copy_entity_txn_id = cea.copy_entity_txn_id
218: AND cet.copy_entity_txn_id = p_copy_entity_txn_id;
219: --
220: