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.PQH_CORPS_UTILITY dependencies on BEN_COPY_ENTITY_RESULTS

Line 67: FROM ben_copy_entity_results

63: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
64:
65: CURSOR csr_gl_currency (p_cet_id IN NUMBER) IS
66: SELECT information50
67: FROM ben_copy_entity_results
68: WHERE copy_entity_txn_id = p_cet_id
69: AND table_alias = 'PGM';
70:
71: CURSOR csr_get_precision

Line 138: instead from ben_copy_entity_results.

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;
142: l_increased_index NUMBER;

Line 164: FROM ben_copy_entity_results

160: l_status varchar2(1) := 'S';
161:
162: CURSOR csr_corps_dflt_plcmt IS
163: SELECT information162, information169
164: FROM ben_copy_entity_results
165: WHERE copy_entity_txn_id = p_copy_entity_txn_id
166: AND information4 = p_business_group_id
167: AND table_alias = 'CPD';
168: l_plip_cer_id number(15);

Line 173: FROM ben_copy_entity_results

169: l_oipl_cer_id number(15);
170:
171: CURSOR csr_dflt_grd_in_grdldr(p_plip_cer_id Number) IS
172: SELECT 'Y'
173: FROM ben_copy_entity_results
174: WHERE copy_entity_txn_id = p_copy_entity_txn_id
175: AND table_alias = 'CPP'
176: AND copy_entity_result_id = p_plip_cer_id
177: AND result_type_cd = 'DISPLAY'

Line 183: FROM ben_copy_entity_results

179: l_grd_exists Varchar2(1);
180:
181: CURSOR csr_dflt_step_in_grdldr(p_oipl_cer_id Number, p_plip_cer_id Number) IS
182: SELECT 'Y'
183: FROM ben_copy_entity_results
184: WHERE copy_entity_txn_id = p_copy_entity_txn_id
185: AND table_alias = 'COP'
186: AND copy_entity_result_id = p_oipl_cer_id
187: AND gs_parent_entity_result_id = p_plip_cer_id

Line 322: FROM ben_copy_entity_results bcer

318: bcer.information105,
319: bcer.information106,
320: bcer.information107,
321: bcer.information108
322: FROM ben_copy_entity_results bcer
323: WHERE bcer.copy_entity_txn_id = p_copy_entity_txn_id
324: AND bcer.table_alias = 'PQH_CORPS_TASK_LIST';
325: l_cpd_control_rec csr_cpd_control_rec%ROWTYPE;
326: BEGIN

Line 522: From Ben_Copy_Entity_Results

518: p_copy_entity_txn_id IN Number) Return Varchar2 IS
519: Cursor csr_seq_no
520: IS
521: Select Information263 -- Sequence Number
522: From Ben_Copy_Entity_Results
523: Where Copy_Entity_Result_Id = p_step_cer_id
524: And Table_Alias = 'COP'
525: And Copy_Entity_Txn_Id = p_copy_entity_txn_id;
526:

Line 530: From Ben_Copy_Entity_Results

526:
527: Cursor csr_point_name
528: IS
529: Select Information98 -- Point Name
530: From Ben_Copy_Entity_Results
531: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
532: And Table_Alias = 'OPT'
533: And Copy_Entity_Result_id = ( select Information262 -- POINT Cer Id
534: From Ben_Copy_Entity_results

Line 534: From Ben_Copy_Entity_results

530: From Ben_Copy_Entity_Results
531: Where Copy_Entity_Txn_Id = p_copy_entity_txn_id
532: And Table_Alias = 'OPT'
533: And Copy_Entity_Result_id = ( select Information262 -- POINT Cer Id
534: From Ben_Copy_Entity_results
535: Where Copy_Entity_Result_id = p_step_cer_id);
536:
537:
538: l_point_name Varchar2(2000);

Line 570: From Ben_Copy_Entity_Results

566: p_dml_operation IN Varchar2) IS
567:
568: Cursor Csr_Ovn IS
569: Select Object_Version_Number
570: From Ben_Copy_Entity_Results
571: Where Copy_Entity_Result_Id = p_crpath_cer_id;
572: l_ovn Number;
573:
574: Begin

Line 581: ben_copy_entity_results_api.delete_copy_entity_results

577: Close Csr_Ovn;
578:
579: If p_dml_operation = 'INSERT' Then
580: -- Purge record
581: ben_copy_entity_results_api.delete_copy_entity_results
582: ( p_copy_entity_result_id => p_crpath_cer_id,
583: p_effective_date => p_effective_date,
584: p_object_version_number => l_ovn);
585:

Line 589: ben_copy_entity_results_api.update_copy_entity_results

585:
586:
587: Else
588: -- UNLINK record
589: ben_copy_entity_results_api.update_copy_entity_results
590: ( p_copy_entity_result_id => p_crpath_cer_id,
591: p_effective_date => p_effective_date,
592: p_information104 => 'UNLINK',
593: p_object_version_number => l_ovn,

Line 606: FROM ben_copy_entity_results

602: Cursor csr_decode_stage_entity(p_cet_id IN NUMBER,
603: p_table_alias IN varchar2,
604: p_cer_id IN NUMBER) IS
605: SELECT information5
606: FROM ben_copy_entity_results
607: WHERE copy_entity_txn_id = p_cet_id
608: AND table_alias = p_table_alias
609: AND copy_entity_result_id = p_cer_id;
610: l_name varchar2(240);

Line 646: FROM BEN_COPY_ENTITY_RESULTS

642: p_copy_entity_result_id In Number) RETURN VARCHAR2
643: IS
644: Cursor csr_career_info IS
645: Select 'Y'
646: FROM BEN_COPY_ENTITY_RESULTS
647: Where Copy_Entity_txn_Id = p_Copy_Entity_txn_Id
648: AND Gs_Mirror_Src_Entity_Result_Id = p_mirror_src_entity_rslt_id
649: AND Information234 = p_from_step_id -- p_from_step_id
650: AND Information227 = p_to_corps_id -- to_corps_id

Line 754: from ben_copy_entity_results

750: l_postStyle varchar2(2);
751:
752: Cursor csr_postStyle is
753: Select information52 post_style
754: from ben_copy_entity_results
755: where table_alias = 'PGM'
756: and copy_entity_txn_id = to_number(p_txn_id);
757:
758: Begin