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_ELEMENTS

Line 1188: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_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:
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:

Line 1236: select criteria_rate_element_id from pqh_criteria_rate_elements

1232: and business_group_id is null));
1233: --
1234:
1235: Cursor csr_cre(crd_id in number,ele_id in number)is
1236: select criteria_rate_element_id from pqh_criteria_rate_elements
1237: where criteria_rate_defn_id = crd_id
1238: and element_type_id = ele_id
1239: and business_group_id = l_business_group_id;
1240: --

Line 1381: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;

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;
1385: --

Line 1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;

1383: l_object_version_number number := 1;
1384: l_business_group_id hr_all_organization_units.business_group_id%type;
1385: --
1386: --
1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;
1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;
1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;
1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;

Line 1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;

1384: l_business_group_id hr_all_organization_units.business_group_id%type;
1385: --
1386: --
1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;
1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;
1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;
1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;
1392: --

Line 1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;

1385: --
1386: --
1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;
1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;
1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;
1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;
1392: --
1393: l_language varchar2(30) ;

Line 1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;

1386: --
1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;
1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;
1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;
1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;
1392: --
1393: l_language varchar2(30) ;
1394:

Line 1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;

1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;
1389: l_creation_date pqh_criteria_rate_elements.creation_date%TYPE;
1390: l_last_update_date pqh_criteria_rate_elements.last_update_date%TYPE;
1391: l_last_update_login pqh_criteria_rate_elements.last_update_login%TYPE;
1392: --
1393: l_language varchar2(30) ;
1394:
1395: Cursor csr_crd is

Line 1421: select criteria_rate_element_id from pqh_criteria_rate_elements

1417: and business_group_id is null));
1418: --
1419:
1420: Cursor csr_cre(crd_id in number,ele_id in number,inp_id in number)is
1421: select criteria_rate_element_id from pqh_criteria_rate_elements
1422: where criteria_rate_defn_id = crd_id
1423: and element_type_id = ele_id
1424: and input_value_id = inp_id
1425: and business_group_id = l_business_group_id;

Line 1428: Select pqh_criteria_rate_elements_s.nextval

1424: and input_value_id = inp_id
1425: and business_group_id = l_business_group_id;
1426: --
1427: Cursor csr_cre_seq is
1428: Select pqh_criteria_rate_elements_s.nextval
1429: From dual;
1430:
1431:
1432: Cursor c1 is select userenv('LANG') from dual ;

Line 1479: update pqh_criteria_rate_elements

1475: Close csr_cre;
1476:
1477:
1478: if l_criteria_rate_element_id is not null then
1479: update pqh_criteria_rate_elements
1480: set
1481: criteria_rate_element_id = l_criteria_rate_element_id
1482: ,criteria_rate_defn_id = l_criteria_rate_defn_id
1483: ,element_type_id = l_element_type_id

Line 1494: insert into pqh_criteria_rate_elements

1490: Open csr_cre_seq;
1491: Fetch csr_cre_seq into l_criteria_rate_element_id;
1492: Close csr_cre_seq;
1493:
1494: insert into pqh_criteria_rate_elements
1495: (criteria_rate_element_id
1496: ,criteria_rate_defn_id
1497: ,element_type_id
1498: ,input_value_id

Line 1531: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;

1527: ) is
1528: --
1529: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1530: l_element_type_id pay_element_types_f.element_type_id%type;
1531: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1532: l_rel_element_type_id pqh_rate_element_relations.rel_element_type_id%type;
1533: l_rel_input_value_id pqh_rate_element_relations.rel_input_value_id%type;
1534: l_relation_type_cd pqh_rate_element_relations.relation_type_cd%type;
1535: l_rate_element_relation_id pqh_rate_element_relations.rate_element_relation_id%type;

Line 1571: select criteria_rate_element_id from pqh_criteria_rate_elements

1567: --
1568:
1569:
1570: Cursor csr_cre(crd_id in number,ele_id in number)is
1571: select criteria_rate_element_id from pqh_criteria_rate_elements
1572: where criteria_rate_defn_id = crd_id
1573: and element_type_id = ele_id
1574: and business_group_id = l_business_group_id;
1575: