APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_POSITIONS

Line 7298: from per_positions

7294: -- pabodla : mapping data
7295: --
7296: cursor c_get_mapping_name14(p_id in number) is
7297: select name
7298: from per_positions
7299: where business_group_id = p_business_group_id
7300: and position_id = p_id;
7301:
7302: cursor c_position_start_date(c_position_id number) is

Line 7304: from per_positions

7300: and position_id = p_id;
7301:
7302: cursor c_position_start_date(c_position_id number) is
7303: select date_effective
7304: from per_positions
7305: where position_id = c_position_id;
7306:
7307: l_pstn_rt_id number(15);
7308: l_out_pst_result_id number(15);

Line 7309: l_position_start_date per_positions.date_effective%type;

7305: where position_id = c_position_id;
7306:
7307: l_pstn_rt_id number(15);
7308: l_out_pst_result_id number(15);
7309: l_position_start_date per_positions.date_effective%type;
7310: ---------------------------------------------------------------
7311: -- END OF BEN_PSTN_RT_F ----------------------
7312: ---------------------------------------------------------------
7313: ---------------------------------------------------------------