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 PAY_INPUT_VALUES_F

Line 1250: select input_value_id from pay_input_values_f

1246: and business_group_id = l_business_group_id;
1247: --
1248: /* dont store id
1249: Cursor csr_rel_inp is
1250: select input_value_id from pay_input_values_f
1251: where name = p_rate_factor_val_record_col
1252: and element_type_id = l_element_type_id
1253: and l_effective_date between effective_start_date and effective_end_date
1254: and business_group_id = l_business_group_id;

Line 1258: select name from pay_input_values_f

1254: and business_group_id = l_business_group_id;
1255: */
1256:
1257: Cursor csr_rel_inp is
1258: select name from pay_input_values_f
1259: where name = p_rate_factor_val_record_col
1260: and element_type_id = l_element_type_id
1261: and l_effective_date between effective_start_date and effective_end_date;
1262:

Line 1380: l_input_value_id pay_input_values_f.input_value_id%type;

1376: ) is
1377:
1378: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1379: l_element_type_id pay_element_types_f.element_type_id%type;
1380: l_input_value_id pay_input_values_f.input_value_id%type;
1381: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1382: l_effective_date Date;
1383: l_object_version_number number := 1;
1384: l_business_group_id hr_all_organization_units.business_group_id%type;

Line 1411: select input_value_id from pay_input_values_f

1407: and business_group_id is null));
1408: --
1409:
1410: Cursor csr_inp is
1411: select input_value_id from pay_input_values_f
1412: where name = p_input_value_name
1413: and element_type_id = l_element_type_id
1414: and l_effective_date between effective_start_date and effective_end_date
1415: and (business_group_id = l_business_group_id OR (legislation_code in

Line 1587: select input_value_id from pay_input_values_f

1583:
1584:
1585:
1586: Cursor csr_rel_inp is
1587: select input_value_id from pay_input_values_f
1588: where name = p_rel_input_val_name
1589: and element_type_id = l_rel_element_type_id
1590: and l_effective_date between effective_start_date and effective_end_date
1591: and business_group_id = l_business_group_id;