APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 1370: from pqh_criteria_rate_elements

1366: and p_effective_date between effective_start_date and effective_end_date;
1367: --
1368: cursor csr_linked_crd (p_element_type_id in number)is
1369: Select criteria_rate_defn_id
1370: from pqh_criteria_rate_elements
1371: Where element_type_id = p_element_type_id;
1372: --
1373: Cursor csr_per_details (p_per_id in number)is
1374: Select *

Line 1500: from pqh_criteria_rate_elements

1496: --
1497: --
1498: cursor csr_linked_crd is
1499: Select criteria_rate_defn_id
1500: from pqh_criteria_rate_elements
1501: Where element_type_id = p_element_type_id;
1502: --
1503: Cursor csr_per_details (p_per_id in number)is
1504: Select *

Line 1686: from pqh_criteria_rate_elements

1682: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1683: --
1684: cursor csr_linked_crd is
1685: Select criteria_rate_defn_id
1686: from pqh_criteria_rate_elements
1687: Where element_type_id = p_element_type_id;
1688: --
1689: l_proc varchar2(72) := g_package||'determine_rbc_rate';
1690: --