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_CRITERIA_RATE_FACTORS

Line 1040: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;

1036: ) is
1037:
1038: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1039: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1040: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;
1042:
1043: l_effective_date Date;
1044: l_object_version_number number := 1;

Line 1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;

1037:
1038: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1039: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1040: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;
1042:
1043: l_effective_date Date;
1044: l_object_version_number number := 1;
1045: l_business_group_id hr_all_organization_units.business_group_id%type;

Line 1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;

1044: l_object_version_number number := 1;
1045: l_business_group_id hr_all_organization_units.business_group_id%type;
1046: --
1047: --
1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;
1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;
1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;

Line 1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;

1045: l_business_group_id hr_all_organization_units.business_group_id%type;
1046: --
1047: --
1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;
1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;
1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;
1053: --

Line 1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;

1046: --
1047: --
1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;
1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;
1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;
1053: --
1054: l_language varchar2(30) ;

Line 1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;

1047: --
1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;
1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;
1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;
1053: --
1054: l_language varchar2(30) ;
1055:

Line 1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;

1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;
1050: l_creation_date pqh_criteria_rate_factors.creation_date%TYPE;
1051: l_last_update_date pqh_criteria_rate_factors.last_update_date%TYPE;
1052: l_last_update_login pqh_criteria_rate_factors.last_update_login%TYPE;
1053: --
1054: l_language varchar2(30) ;
1055:
1056: Cursor c1 is select userenv('LANG') from dual ;

Line 1071: select criteria_rate_factor_id from pqh_criteria_rate_factors

1067: where short_name = p_parent_crit_rt_def_name
1068: and business_group_id = l_business_group_id;
1069:
1070: Cursor csr_crf(crd_id in number,crdp_id in number)is
1071: select criteria_rate_factor_id from pqh_criteria_rate_factors
1072: where criteria_rate_defn_id = crd_id
1073: and parent_criteria_rate_defn_id = crdp_id
1074: and business_group_id = l_business_group_id;
1075: --

Line 1077: Select pqh_criteria_rate_factors_s.nextval

1073: and parent_criteria_rate_defn_id = crdp_id
1074: and business_group_id = l_business_group_id;
1075: --
1076: Cursor csr_crf_seq is
1077: Select pqh_criteria_rate_factors_s.nextval
1078: From dual;
1079:
1080: /* Cursor csr_prm is
1081: select pl_id from ben_pl_f

Line 1133: update pqh_criteria_rate_factors

1129: */
1130: l_parent_rate_matrix_id := get_plan_id(p_parent_rate_matrix_code,l_effective_date,l_business_group_id);
1131:
1132: if(l_criteria_rate_factor_id is not null) then
1133: update pqh_criteria_rate_factors
1134: set
1135: criteria_rate_defn_id = l_criteria_rate_defn_id
1136: ,parent_rate_matrix_id = l_parent_rate_matrix_id
1137: ,parent_criteria_rate_defn_id = l_parent_criteria_rate_defn_id

Line 1149: insert into pqh_criteria_rate_factors

1145: Fetch csr_crf_seq into l_criteria_rate_factor_id;
1146: Close csr_crf_seq;
1147:
1148:
1149: insert into pqh_criteria_rate_factors
1150: (criteria_rate_factor_id
1151: ,criteria_rate_defn_id
1152: ,parent_rate_matrix_id
1153: ,parent_criteria_rate_defn_id

Line 1185: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;

1181: ) is
1182:
1183: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1184: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1185: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1186:
1187: l_element_type_id pay_element_types_f.element_type_id%type;
1188: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1189:

Line 1221: select criteria_rate_factor_id from pqh_criteria_rate_factors

1217: where short_name = p_parent_crit_rt_def_name
1218: and business_group_id = l_business_group_id;
1219:
1220: Cursor csr_crf(crd_id in number,crdp_id in number)is
1221: select criteria_rate_factor_id from pqh_criteria_rate_factors
1222: where criteria_rate_defn_id = crd_id
1223: and parent_criteria_rate_defn_id = crdp_id
1224: and business_group_id = l_business_group_id;
1225: