APPS.PQP_US_STUDENT_BEE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 111: from pay_element_entry_values_f pev

107: ,c_end_date in Date
108: ,c_input_value_id in Number
109: ) Is
110: Select pev.screen_entry_value
111: from pay_element_entry_values_f pev
112: where pev.input_value_id = c_input_value_id
113: and pev.element_entry_id = c_element_entry_id
114: and (c_end_date between pev.effective_start_date
115: and pev.effective_end_date

Line 144: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type

140: -- Define the record structure for holding the elements input names.
141: type input_values_rec is record
142: (input_value_id number(10)
143: ,name pay_input_values_f.name%type
144: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type
145: ,display_sequence pay_input_values_f.display_sequence%type
146: ,lookup_type pay_input_values_f.lookup_type%type
147: ,default_value pay_input_values_f.default_value%type
148: ,max_value pay_input_values_f.max_value%type

Line 250: l_authId_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;

246: l_ele_entry_ed_date Date;
247: l_new_Maxdiff_amt Number;
248: l_authId_ipv_id pay_input_values_f.input_value_id%TYPE;
249: l_awdId_name pay_input_values_f.name%TYPE;
250: l_authId_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;
251:
252: l_maxAmt_ipvId pay_input_values_f.input_value_id%TYPE;
253: l_maxAmt_name pay_input_values_f.name%TYPE;
254: l_maxAmt_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;

Line 254: l_maxAmt_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;

250: l_authId_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;
251:
252: l_maxAmt_ipvId pay_input_values_f.input_value_id%TYPE;
253: l_maxAmt_name pay_input_values_f.name%TYPE;
254: l_maxAmt_ipv_value pay_element_entry_values_f.screen_entry_value%TYPE;
255: l_count number;
256:
257: Begin
258: