eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on BEN_COPY_ENTITY_TXNS_VW

Line 633: from ben_copy_entity_txns_vw

629: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
630: --
631: cursor c_copy_entity_attrib is
632: select copy_entity_attrib_id,cea_object_version_number
633: from ben_copy_entity_txns_vw
634: where copy_entity_txn_id = p_copy_entity_txn_id;
635: --
636: cursor c_cer is
637: select cer.*

Line 2428: from ben_copy_entity_txns_vw cet,

2424: ,cet.target_typ_cd
2425: ,cet.information30 source_business_group_name
2426: ,cet.action_date
2427: ,tcg.short_name
2428: from ben_copy_entity_txns_vw cet,
2429: pqh_transaction_categories tcg
2430: where cet.copy_entity_txn_id = c_copy_entity_txn_id
2431: and cet.transaction_category_id = tcg.transaction_category_id;
2432:

Line 4824: from ben_copy_entity_txns_vw cet,

4820: ,cet.cet_object_version_number
4821: ,cet.action_date
4822: ,cet.sfl_step_name
4823: ,tcg.short_name
4824: from ben_copy_entity_txns_vw cet,
4825: pqh_transaction_categories tcg
4826: where cet.copy_entity_txn_id = p_copy_entity_txn_id
4827: and cet.transaction_category_id = tcg.transaction_category_id;
4828:

Line 4857: l_process_name ben_copy_entity_txns_vw.process_name%type;

4853: where copy_entity_txn_id = p_copy_entity_txn_id;
4854: --
4855:
4856: l_copy_entity_txn c_copy_entity_txn%rowtype;
4857: l_process_name ben_copy_entity_txns_vw.process_name%type;
4858: l_target_type_cd ben_copy_entity_txns_vw.target_typ_cd%type;
4859: l_src_effective_date varchar2(15);
4860: l_export_file_name ben_copy_entity_txns_vw.export_file_name%type;
4861:

Line 4858: l_target_type_cd ben_copy_entity_txns_vw.target_typ_cd%type;

4854: --
4855:
4856: l_copy_entity_txn c_copy_entity_txn%rowtype;
4857: l_process_name ben_copy_entity_txns_vw.process_name%type;
4858: l_target_type_cd ben_copy_entity_txns_vw.target_typ_cd%type;
4859: l_src_effective_date varchar2(15);
4860: l_export_file_name ben_copy_entity_txns_vw.export_file_name%type;
4861:
4862: l_request_id number := null;

Line 4860: l_export_file_name ben_copy_entity_txns_vw.export_file_name%type;

4856: l_copy_entity_txn c_copy_entity_txn%rowtype;
4857: l_process_name ben_copy_entity_txns_vw.process_name%type;
4858: l_target_type_cd ben_copy_entity_txns_vw.target_typ_cd%type;
4859: l_src_effective_date varchar2(15);
4860: l_export_file_name ben_copy_entity_txns_vw.export_file_name%type;
4861:
4862: l_request_id number := null;
4863: l_mode_param varchar2(50) := 'DOWNLOAD';
4864: l_loader_config_param varchar2(50) := '@ben:/patch/115/import/bencer.lct';

Line 5254: from ben_copy_entity_txns_vw cet

5250: cursor c_copy_entity_txn is
5251: select cet.src_effective_date effective_date
5252: ,cet.cet_object_version_number
5253: ,cet.sfl_step_name
5254: from ben_copy_entity_txns_vw cet
5255: where cet.copy_entity_txn_id = p_copy_entity_txn_id ;
5256: --
5257: l_start_with pqh_copy_entity_txns.start_with%type;
5258: begin

Line 5432: FROM ben_copy_entity_txns_vw cet

5428: ,cet.status
5429: ,cet.target_typ_cd),
5430: 'LogEnabled','Y',
5431: 'LogDisabled','N', 'N') log_status
5432: FROM ben_copy_entity_txns_vw cet
5433: WHERE cet.transaction_category_id =
5434: (SELECT ptc.transaction_category_id
5435: FROM PQH_TRANSACTION_CATEGORIES ptc
5436: WHERE ptc.short_name = p_transaction_short_name)