APPS.PQP_US_STUDENT_BEE dependencies on PAY_INPUT_VALUES_F

Line 58: from pay_input_values_f piv

54: ,piv.max_value
55: ,piv.min_value
56: ,piv.default_value
57: ,piv.warning_or_error
58: from pay_input_values_f piv
59: where piv.element_type_id = c_ele_type_id
60: and c_effective_date between piv.effective_start_date
61: and piv.effective_end_date
62: order by piv.display_sequence;

Line 127: from pay_input_values_f piv

123: cursor ipv_id (c_ele_type_id in number
124: ,c_ipv_name in varchar2) is
125: select piv.input_value_id
126: ,piv.name
127: from pay_input_values_f piv
128: where piv.element_type_id = c_ele_type_id
129: and piv.name = c_ipv_name
130: order by piv.display_sequence;
131: -- Get the latest start and end date for the element entry id.

Line 143: ,name pay_input_values_f.name%type

139:
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

Line 145: ,display_sequence pay_input_values_f.display_sequence%type

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
149: ,min_value pay_input_values_f.min_value%type

Line 146: ,lookup_type pay_input_values_f.lookup_type%type

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
149: ,min_value pay_input_values_f.min_value%type
150: ,warning_or_error pay_input_values_f.warning_or_error%type

Line 147: ,default_value pay_input_values_f.default_value%type

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
149: ,min_value pay_input_values_f.min_value%type
150: ,warning_or_error pay_input_values_f.warning_or_error%type
151: );

Line 148: ,max_value pay_input_values_f.max_value%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
149: ,min_value pay_input_values_f.min_value%type
150: ,warning_or_error pay_input_values_f.warning_or_error%type
151: );
152: -- Record type declaration

Line 149: ,min_value pay_input_values_f.min_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
149: ,min_value pay_input_values_f.min_value%type
150: ,warning_or_error pay_input_values_f.warning_or_error%type
151: );
152: -- Record type declaration
153: type t_input_values is table of input_values_rec

Line 150: ,warning_or_error pay_input_values_f.warning_or_error%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
149: ,min_value pay_input_values_f.min_value%type
150: ,warning_or_error pay_input_values_f.warning_or_error%type
151: );
152: -- Record type declaration
153: type t_input_values is table of input_values_rec
154: index by binary_integer;

Line 248: l_authId_ipv_id pay_input_values_f.input_value_id%TYPE;

244: l_end_date Date;
245: l_ele_entry_st_date Date;
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;

Line 249: l_awdId_name pay_input_values_f.name%TYPE;

245: l_ele_entry_st_date Date;
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;

Line 252: l_maxAmt_ipvId pay_input_values_f.input_value_id%TYPE;

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;
255: l_count number;
256:

Line 253: l_maxAmt_name pay_input_values_f.name%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;
255: l_count number;
256:
257: Begin