APPS.PAY_JP_RESULT_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 29: TYPE result_values_t IS TABLE OF PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

25: -- Bulk Result informations.
26: --
27: -- To execute bulk fetch, nested loop(or VARRAY) is mandatory.
28: --
29: TYPE result_values_t IS TABLE OF PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
30: TYPE data_types_t IS TABLE OF VARCHAR2(30);
31: /* BUG1899306: Modified not to use an object type. ***********
32: l_input_value_ids pay_jp_numbers_t;
33: *********************************************************** */

Line 68: pay_run_result_values prrv, -- Run result value

64: )
65: ),
66: min(distinct prrv.result_value)) RESULT_VALUE
67: from
68: pay_run_result_values prrv, -- Run result value
69: pay_run_results prr, -- Run result
70: pay_input_values_f piv
71: where prr.assignment_action_id = p_assignment_action_id
72: and prr.status in ('P','PA')

Line 86: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

82: --
83: l_result_values_by_iv result_values_by_iv_t;
84: l_input_value_id NUMBER;
85: l_data_type hr_lookups.LOOKUP_CODE%TYPE;
86: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
87: BEGIN
88: --
89: -- Get all result values with bulk collect.
90: --

Line 174: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

170: l_balance_type_id NUMBER;
171: l_concat_bal VARCHAR2(32767);
172: l_input_value_id NUMBER;
173: l_concat_iv VARCHAR2(32767);
174: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
175: BEGIN
176: --
177: -- Setup balance values.
178: --

Line 323: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;

319: FUNCTION result_value(
320: p_result_values_by_iv IN result_values_by_iv_t,
321: p_input_value_id IN NUMBER) RETURN VARCHAR2
322: IS
323: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
324: BEGIN
325: if p_input_value_id is not NULL then
326: if p_result_values_by_iv.exists(p_input_value_id) then
327: l_result_value := p_result_values_by_iv(p_input_value_id).result_value;