APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PAY_INPUT_VALUES_F

Line 15: name pay_input_values_f.name%TYPE

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

Line 16: , id pay_input_values_f.input_value_id%TYPE

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

Line 44: p_ipv_name OUT NOCOPY PAY_INPUT_VALUES_F.NAME%TYPE

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

Line 109: from pay_input_values_f piv

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

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

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

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

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

Line 220: l_ipv_name PAY_INPUT_VALUES_F.NAME%TYPE;

216: p_segment OUT NOCOPY t_segment)
217: IS
218: --
219:
220: l_ipv_name PAY_INPUT_VALUES_F.NAME%TYPE;
221: l_ipv_count NUMBER := 0;
222: --
223: --
224: l_seq NUMBER(5);

Line 235: l_iv_id_1 pay_input_values_f.input_value_id%TYPE;

231: l_iv_map_cached BOOLEAN;
232: l_iter BINARY_INTEGER;
233: l_index_input_value BINARY_INTEGER;
234: lcode HR_LOOKUPS.lookup_code%TYPE;
235: l_iv_id_1 pay_input_values_f.input_value_id%TYPE;
236:
237:
238: l_ivn_cached BOOLEAN;
239: l_is_hour BOOLEAN;

Line 1037: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv

1033: cursor c_check_pto (p_bg_id NUMBER,p_element_type_id NUMBER,p_effective_date IN DATE)
1034: IS
1035: SELECT pnt.DATE_INPUT_VALUE_id DATE_INPUT_VALUE_id,
1036: pnt.accrual_plan_id accrual_plan_id
1037: FROM PAY_NET_CALCULATION_RULES pnt,PAY_INPUT_VALUES_F piv
1038: WHERE piv.business_group_id=p_bg_id
1039: and pnt.DATE_INPUT_VALUE_id=piv.INPUT_VALUE_ID
1040: and piv.element_type_ID=p_element_type_id
1041: AND p_effective_date between piv.effective_start_date and piv.effective_end_date

Line 1052: from pay_input_values_f

1048: ) RETURN VARCHAR2 IS
1049:
1050: cursor c_ipvs(p_element_type_id in number, p_effective_date in date) is
1051: select display_sequence, name, input_value_id, mandatory_flag
1052: from pay_input_values_f
1053: where element_type_id = p_element_type_id
1054: and p_effective_date between effective_start_date and effective_end_date
1055: order by display_sequence, name;
1056: