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_FACTOR_ON_ELMNTS

Line 1190: l_rate_factor_on_elmnt_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_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:
1190: l_rate_factor_on_elmnt_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;
1191: l_rate_factor_val_record_col pqh_rate_factor_on_elmnts.rate_factor_val_record_col%type;
1192:
1193: l_effective_date Date;
1194: l_object_version_number number := 1;

Line 1191: l_rate_factor_val_record_col pqh_rate_factor_on_elmnts.rate_factor_val_record_col%type;

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:
1190: l_rate_factor_on_elmnt_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;
1191: l_rate_factor_val_record_col pqh_rate_factor_on_elmnts.rate_factor_val_record_col%type;
1192:
1193: l_effective_date Date;
1194: l_object_version_number number := 1;
1195: l_business_group_id hr_all_organization_units.business_group_id%type;

Line 1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;

1194: l_object_version_number number := 1;
1195: l_business_group_id hr_all_organization_units.business_group_id%type;
1196: --
1197: --
1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;
1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;
1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;

Line 1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;

1195: l_business_group_id hr_all_organization_units.business_group_id%type;
1196: --
1197: --
1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;
1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;
1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;
1203: --

Line 1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;

1196: --
1197: --
1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;
1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;
1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;
1203: --
1204: l_language varchar2(30) ;

Line 1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;

1197: --
1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;
1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;
1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;
1203: --
1204: l_language varchar2(30) ;
1205:

Line 1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;

1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;
1200: l_creation_date pqh_rate_factor_on_elmnts.creation_date%TYPE;
1201: l_last_update_date pqh_rate_factor_on_elmnts.last_update_date%TYPE;
1202: l_last_update_login pqh_rate_factor_on_elmnts.last_update_login%TYPE;
1203: --
1204: l_language varchar2(30) ;
1205:
1206: Cursor c1 is select userenv('LANG') from dual ;

Line 1243: select rate_factor_on_elmnt_id from pqh_rate_factor_on_elmnts

1239: and business_group_id = l_business_group_id;
1240: --
1241:
1242: Cursor csr_rfe(crf_id in number,cre_id in number)is
1243: select rate_factor_on_elmnt_id from pqh_rate_factor_on_elmnts
1244: where criteria_rate_factor_id = crf_id
1245: and criteria_rate_element_id = cre_id
1246: and business_group_id = l_business_group_id;
1247: --

Line 1265: Select pqh_rate_factor_on_elmnts_s.nextval

1261: and l_effective_date between effective_start_date and effective_end_date;
1262:
1263:
1264: Cursor csr_rfe_seq is
1265: Select pqh_rate_factor_on_elmnts_s.nextval
1266: From dual;
1267:
1268: Begin
1269: --

Line 1329: update pqh_rate_factor_on_elmnts

1325: close csr_rfe;
1326:
1327:
1328: if(l_rate_factor_on_elmnt_id is not null) then
1329: update pqh_rate_factor_on_elmnts
1330: set
1331: rate_factor_on_elmnt_id =l_rate_factor_on_elmnt_id
1332: ,criteria_rate_element_id =l_criteria_rate_element_id
1333: ,criteria_rate_factor_id =l_criteria_rate_factor_id

Line 1344: insert into pqh_rate_factor_on_elmnts

1340: else
1341: Open csr_rfe_seq;
1342: Fetch csr_rfe_seq into l_rate_factor_on_elmnt_id;
1343: Close csr_rfe_seq;
1344: insert into pqh_rate_factor_on_elmnts
1345: (rate_factor_on_elmnt_id
1346: ,criteria_rate_element_id
1347: ,criteria_rate_factor_id
1348: ,rate_factor_val_record_tbl