DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on PAY_INPUT_VALUES_F

Line 250: SEQUENCE pay_input_values_f.input_value_id%TYPE,

246: l_batch_line_ovn number;
247:
248: -- Bug 12993528
249: TYPE input_value_record IS RECORD (
250: SEQUENCE pay_input_values_f.input_value_id%TYPE,
251: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
252: lookup pay_input_values_f.lookup_type%TYPE,
253: otl_sequence NUMBER);
254:

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

247:
248: -- Bug 12993528
249: TYPE input_value_record IS RECORD (
250: SEQUENCE pay_input_values_f.input_value_id%TYPE,
251: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
252: lookup pay_input_values_f.lookup_type%TYPE,
253: otl_sequence NUMBER);
254:
255: TYPE input_values_table IS TABLE OF input_value_record

Line 252: lookup pay_input_values_f.lookup_type%TYPE,

248: -- Bug 12993528
249: TYPE input_value_record IS RECORD (
250: SEQUENCE pay_input_values_f.input_value_id%TYPE,
251: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
252: lookup pay_input_values_f.lookup_type%TYPE,
253: otl_sequence NUMBER);
254:
255: TYPE input_values_table IS TABLE OF input_value_record
256: INDEX BY BINARY_INTEGER;

Line 274: pay_input_values_f piv,

270: )
271: IS
272: SELECT DISTINCT piv.NAME -- PIV.display_sequence
273: FROM --pay_element_types_f PET
274: pay_input_values_f piv,
275: pay_accrual_plans pap,
276: pay_net_calculation_rules pncr
277: WHERE --PET.element_type_id = cp_element_type_id
278:

Line 2732: SEQUENCE pay_input_values_f.input_value_id%TYPE,

2728: FROM pay_batch_lines pbl
2729: WHERE pbl.batch_line_id = c_line_id;
2730:
2731: TYPE input_value_record IS RECORD (
2732: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2733: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2734: lookup pay_input_values_f.lookup_type%TYPE);
2735:
2736: TYPE input_values_table IS TABLE OF input_value_record

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

2729: WHERE pbl.batch_line_id = c_line_id;
2730:
2731: TYPE input_value_record IS RECORD (
2732: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2733: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2734: lookup pay_input_values_f.lookup_type%TYPE);
2735:
2736: TYPE input_values_table IS TABLE OF input_value_record
2737: INDEX BY BINARY_INTEGER;

Line 2734: lookup pay_input_values_f.lookup_type%TYPE);

2730:
2731: TYPE input_value_record IS RECORD (
2732: SEQUENCE pay_input_values_f.input_value_id%TYPE,
2733: NAME pay_input_values_f_tl.NAME%TYPE, --FORMS60
2734: lookup pay_input_values_f.lookup_type%TYPE);
2735:
2736: TYPE input_values_table IS TABLE OF input_value_record
2737: INDEX BY BINARY_INTEGER;
2738: