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_RBC_LOAD_OBJECTS dependencies on PQH_RATE_MATRIX_RATES_F

Line 526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;

522:
523: --
524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;

Line 527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;

523: --
524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;
531: l_ovn number := 1;

Line 581: From pqh_rate_matrix_rates_f

577: and mapping_table_pk_id = l_crd_id;
578: --
579: Cursor csr_rmr is
580: Select rate_matrix_rate_id ,object_version_number
581: From pqh_rate_matrix_rates_f
582: Where criteria_rate_defn_id = l_crd_id
583: and rate_matrix_node_id = l_rate_matrix_node_id
584: and l_effective_date between effective_start_date and effective_end_date
585: and business_group_id = l_business_group_id;

Line 659: Insert into pqh_rate_matrix_rates_f

655: End if;
656: --
657: /**
658: l_ovn := 1;
659: Insert into pqh_rate_matrix_rates_f
660: (RATE_MATRIX_RATE_ID,
661: EFFECTIVE_START_DATE,
662: EFFECTIVE_END_DATE,
663: RATE_MATRIX_NODE_ID,

Line 717: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode('PQH_RATE_MATRIX_RATES_F','RATE_MATRIX_RATE_ID', l_rt_matrix_rate_id, l_effective_date) ;

713: ,p_object_version_number => l_ovn
714: );
715:
716: Else
717: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode('PQH_RATE_MATRIX_RATES_F','RATE_MATRIX_RATE_ID', l_rt_matrix_rate_id, l_effective_date) ;
718:
719: PQH_RATE_MATRIX_RATES_API.update_rate_matrix_rate(
720: p_effective_date => l_effective_date
721: ,p_business_group_id => l_business_group_id