APPS.PQH_RBC_UTILITY dependencies on BEN_PL_F

Line 257: select effective_start_date from ben_pl_f

253:
254: FUNCTION get_matrix_disable_date(p_pl_id in number,p_effective_date in date) RETURN Date IS
255: l_effective_start_date Date;
256: cursor c1 is
257: select effective_start_date from ben_pl_f
258: where pl_id = p_pl_id
259: and pl_stat_cd = 'I'
260: and effective_start_date > p_effective_date
261: order by effective_start_date;

Line 1367: l_curr_rate_matrix_id ben_pl_f.pl_id%type;

1363: l_criteria_rate_defn_name ben_copy_entity_results.information5%type;
1364: l_curr_order_number ben_copy_entity_results.information160%type;
1365: l_new_order_number ben_copy_entity_results.information160%type := 0;
1366: l_parent pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1367: l_curr_rate_matrix_id ben_pl_f.pl_id%type;
1368: --
1369: Cursor csr_ref_crd is
1370: Select copy_entity_result_id, information1 , nvl(information5,'name') crd_name,information160
1371: from ben_copy_entity_results