APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_INPUT_VALUES_F

Line 17: name pay_input_values_f.name%TYPE

13: --
14: TYPE t_segment IS TABLE OF varchar2(60) INDEX BY BINARY_INTEGER;
15:
16: TYPE r_input_value IS RECORD (
17: name pay_input_values_f.name%TYPE
18: , id pay_input_values_f.input_value_id%TYPE
19: , value VARCHAR2(80));
20: TYPE t_input_value IS TABLE OF r_input_value INDEX BY BINARY_INTEGER;
21:

Line 18: , id pay_input_values_f.input_value_id%TYPE

14: TYPE t_segment IS TABLE OF varchar2(60) INDEX BY BINARY_INTEGER;
15:
16: TYPE r_input_value IS RECORD (
17: name pay_input_values_f.name%TYPE
18: , id pay_input_values_f.input_value_id%TYPE
19: , value VARCHAR2(80));
20: TYPE t_input_value IS TABLE OF r_input_value INDEX BY BINARY_INTEGER;
21:
22:

Line 46: p_ipv_name OUT NOCOPY PAY_INPUT_VALUES_F.NAME%TYPE

42:
43: -----------------------------------------------------------------------
44: PROCEDURE get_input_value_name (p_element_type_id IN number,
45: p_field_name IN VARCHAR2,
46: p_ipv_name OUT NOCOPY PAY_INPUT_VALUES_F.NAME%TYPE
47: )
48: IS
49: l_ivn_cached BOOLEAN := false;
50: l_iter BINARY_INTEGER;

Line 111: from pay_input_values_f piv

107: p_effective_date in date) IS
108: select piv.name, piv.input_value_id, piv.display_sequence,
109: piv.effective_start_date, piv.effective_end_date,
110: piv.uom
111: from pay_input_values_f piv
112: where piv.element_type_id = p_element_type_id
113: and p_effective_date between piv.effective_start_date
114: and piv.effective_end_date
115: order by piv.display_sequence

Line 151: PROCEDURE get_iv_map(p_ipv_name IN PAY_INPUT_VALUES_F.NAME%TYPE,

147: end if;
148:
149: END populate_iv_map;
150: --------------------------------------------------------------------------
151: PROCEDURE get_iv_map(p_ipv_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
152: p_cnt IN NUMBER,
153: p_seq OUT NOCOPY NUMBER,
154: p_iv_id OUT NOCOPY pay_input_values_f.input_value_id%TYPE,
155: p_is_hour OUT NOCOPY BOOLEAN)

Line 154: p_iv_id OUT NOCOPY pay_input_values_f.input_value_id%TYPE,

150: --------------------------------------------------------------------------
151: PROCEDURE get_iv_map(p_ipv_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
152: p_cnt IN NUMBER,
153: p_seq OUT NOCOPY NUMBER,
154: p_iv_id OUT NOCOPY pay_input_values_f.input_value_id%TYPE,
155: p_is_hour OUT NOCOPY BOOLEAN)
156: IS
157:
158: l_iter BINARY_INTEGER;

Line 225: l_ipv_name PAY_INPUT_VALUES_F.NAME%TYPE;

221: p_segment OUT NOCOPY t_segment)
222: IS
223: --
224:
225: l_ipv_name PAY_INPUT_VALUES_F.NAME%TYPE;
226: l_ipv_count NUMBER := 0;
227: --
228: --
229: l_seq NUMBER(5);

Line 240: l_iv_id_1 pay_input_values_f.input_value_id%TYPE;

236: l_iv_map_cached BOOLEAN;
237: l_iter BINARY_INTEGER;
238: l_index_input_value BINARY_INTEGER;
239: lcode HR_LOOKUPS.lookup_code%TYPE;
240: l_iv_id_1 pay_input_values_f.input_value_id%TYPE;
241:
242:
243: l_ivn_cached BOOLEAN;
244: l_is_hour BOOLEAN;

Line 1063: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv

1059: cursor c_check_pto (p_bg_id NUMBER,p_element_type_id NUMBER,p_effective_date IN DATE)
1060: IS
1061: SELECT pnt.DATE_INPUT_VALUE_id DATE_INPUT_VALUE_id,
1062: pnt.accrual_plan_id accrual_plan_id
1063: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv
1064: WHERE piv.business_group_id=p_bg_id
1065: and pnt.DATE_INPUT_VALUE_id=piv.INPUT_VALUE_ID
1066: and piv.element_type_ID=p_element_type_id
1067: AND p_effective_date between piv.effective_start_date and piv.effective_end_date

Line 1083: FROM pay_input_values_f iv

1079: p_effective_date in date,
1080: p_iv_id NUMBER)
1081: IS
1082: SELECT to_number (replace (fdfcu.application_column_name, 'ATTRIBUTE')) otl_sequence
1083: FROM pay_input_values_f iv
1084: , fnd_descr_flex_column_usages fdfcu
1085: WHERE p_effective_date
1086: BETWEEN iv.effective_start_date
1087: AND iv.effective_end_date