APPS.HXT_RETRO_MIX dependencies on PAY_INPUT_VALUES_F

Line 216: SEQUENCE pay_input_values_f.input_value_id%TYPE,

212: l_batch_line_id number;
213: l_batch_line_ovn number;
214:
215: TYPE input_value_record IS RECORD (
216: SEQUENCE pay_input_values_f.input_value_id%TYPE,
217: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
218: lookup pay_input_values_f.lookup_type%TYPE);
219:
220: TYPE input_values_table IS TABLE OF input_value_record

Line 217: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60

213: l_batch_line_ovn number;
214:
215: TYPE input_value_record IS RECORD (
216: SEQUENCE pay_input_values_f.input_value_id%TYPE,
217: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
218: lookup pay_input_values_f.lookup_type%TYPE);
219:
220: TYPE input_values_table IS TABLE OF input_value_record
221: INDEX BY BINARY_INTEGER;

Line 218: lookup pay_input_values_f.lookup_type%TYPE);

214:
215: TYPE input_value_record IS RECORD (
216: SEQUENCE pay_input_values_f.input_value_id%TYPE,
217: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
218: lookup pay_input_values_f.lookup_type%TYPE);
219:
220: TYPE input_values_table IS TABLE OF input_value_record
221: INDEX BY BINARY_INTEGER;
222:

Line 239: pay_input_values_f piv,

235: )
236: IS
237: SELECT DISTINCT piv.NAME -- PIV.display_sequence
238: FROM --pay_element_types_f PET
239: pay_input_values_f piv,
240: pay_accrual_plans pap,
241: pay_net_calculation_rules pncr
242: WHERE --PET.element_type_id = cp_element_type_id
243:

Line 2354: SEQUENCE pay_input_values_f.input_value_id%TYPE,

2350: FROM pay_batch_lines pbl
2351: WHERE pbl.batch_line_id = c_line_id;
2352:
2353: TYPE input_value_record IS RECORD (
2354: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2355: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2356: lookup pay_input_values_f.lookup_type%TYPE);
2357:
2358: TYPE input_values_table IS TABLE OF input_value_record

Line 2355: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60

2351: WHERE pbl.batch_line_id = c_line_id;
2352:
2353: TYPE input_value_record IS RECORD (
2354: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2355: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2356: lookup pay_input_values_f.lookup_type%TYPE);
2357:
2358: TYPE input_values_table IS TABLE OF input_value_record
2359: INDEX BY BINARY_INTEGER;

Line 2356: lookup pay_input_values_f.lookup_type%TYPE);

2352:
2353: TYPE input_value_record IS RECORD (
2354: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2355: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2356: lookup pay_input_values_f.lookup_type%TYPE);
2357:
2358: TYPE input_values_table IS TABLE OF input_value_record
2359: INDEX BY BINARY_INTEGER;
2360: