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_ELEMENT_RELATIONS

Line 1532: l_rel_element_type_id pqh_rate_element_relations.rel_element_type_id%type;

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;
1536: l_effective_date Date;

Line 1533: l_rel_input_value_id pqh_rate_element_relations.rel_input_value_id%type;

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;
1536: l_effective_date Date;
1537:

Line 1534: l_relation_type_cd pqh_rate_element_relations.relation_type_cd%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;
1536: l_effective_date Date;
1537:
1538: l_object_version_number number := 1;

Line 1535: l_rate_element_relation_id pqh_rate_element_relations.rate_element_relation_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;
1536: l_effective_date Date;
1537:
1538: l_object_version_number number := 1;
1539: l_business_group_id hr_all_organization_units.business_group_id%type;

Line 1542: l_created_by pqh_rate_element_relations.created_by%TYPE;

1538: l_object_version_number number := 1;
1539: l_business_group_id hr_all_organization_units.business_group_id%type;
1540: --
1541: --
1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;
1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;
1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;
1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;

Line 1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;

1539: l_business_group_id hr_all_organization_units.business_group_id%type;
1540: --
1541: --
1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;
1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;
1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;
1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;
1547: --

Line 1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;

1540: --
1541: --
1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;
1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;
1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;
1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;
1547: --
1548: l_language varchar2(30) ;

Line 1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;

1541: --
1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;
1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;
1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;
1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;
1547: --
1548: l_language varchar2(30) ;
1549:

Line 1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;

1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;
1544: l_creation_date pqh_rate_element_relations.creation_date%TYPE;
1545: l_last_update_date pqh_rate_element_relations.last_update_date%TYPE;
1546: l_last_update_login pqh_rate_element_relations.last_update_login%TYPE;
1547: --
1548: l_language varchar2(30) ;
1549:
1550:

Line 1596: select rate_element_relation_id from pqh_rate_element_relations

1592: --
1593:
1594:
1595: Cursor csr_rer(cre_id in number,rel_ele in number)is
1596: select rate_element_relation_id from pqh_rate_element_relations
1597: where criteria_rate_element_id = cre_id
1598: and relation_type_cd = p_relation_type_code
1599: and rel_element_type_id = rel_ele
1600: and business_group_id = l_business_group_id;

Line 1604: Select pqh_rate_element_relations_s.nextval

1600: and business_group_id = l_business_group_id;
1601: --
1602: --
1603: Cursor csr_rer_seq is
1604: Select pqh_rate_element_relations_s.nextval
1605: From dual;
1606:
1607:
1608: Begin

Line 1665: update pqh_rate_element_relations

1661: close csr_rer;
1662:
1663: if l_rate_element_relation_id is not null then
1664:
1665: update pqh_rate_element_relations
1666: set
1667: rate_element_relation_id = l_rate_element_relation_id
1668: ,criteria_rate_element_id = l_criteria_rate_element_id
1669: ,relation_type_cd = p_relation_type_code

Line 1682: insert into pqh_rate_element_relations

1678: Open csr_rer_seq;
1679: Fetch csr_rer_seq into l_rate_element_relation_id;
1680: Close csr_rer_seq;
1681:
1682: insert into pqh_rate_element_relations
1683: (rate_element_relation_id
1684: ,criteria_rate_element_id
1685: ,relation_type_cd
1686: ,rel_element_type_id