APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 142: FROM pay_input_values_f piv,

138: p_effective_date DATE)
139: IS
140: SELECT piv.uom,
141: pivtl.name
142: FROM pay_input_values_f piv,
143: pay_input_values_f_tl pivtl
144: WHERE piv.input_value_id = p_input_value_id
145: AND pivtl.input_value_id = piv.input_value_id
146: AND pivtl.language = userenv('LANG')

Line 143: pay_input_values_f_tl pivtl

139: IS
140: SELECT piv.uom,
141: pivtl.name
142: FROM pay_input_values_f piv,
143: pay_input_values_f_tl pivtl
144: WHERE piv.input_value_id = p_input_value_id
145: AND pivtl.input_value_id = piv.input_value_id
146: AND pivtl.language = userenv('LANG')
147: AND p_effective_date BETWEEN piv.effective_start_date

Line 154: l_uom pay_input_values_f.uom%TYPE;

150:
151: l_action_info_id NUMBER;
152: l_index NUMBER := 0;
153: l_ovn NUMBER;
154: l_uom pay_input_values_f.uom%TYPE;
155: l_context VARCHAR2(30);
156: l_element_index PLS_INTEGER :=0;
157: l_balance_index PLS_INTEGER :=0;
158: l_element_type_id NUMBER;

Line 162: l_input_value_name pay_input_values_f.name%TYPE;

158: l_element_type_id NUMBER;
159: l_element_name pay_element_types_f.reporting_name%TYPE;
160: l_input_value_id NUMBER;
161: l_element_narrative VARCHAR2(150);
162: l_input_value_name pay_input_values_f.name%TYPE;
163:
164:
165: BEGIN
166: g_debug := hr_utility.debug_enabled;

Line 336: ,pay_input_values_f PIVF

332: CURSOR csr_set_source_id(p_run_assignment_action_id pay_assignment_actions.tax_unit_id%type)
333: IS
334: select distinct CONTEXT.result_value
335: from pay_run_result_values CONTEXT
336: ,pay_input_values_f PIVF
337: ,pay_run_results RR
338: ,pay_payroll_actions PACT,
339: pay_assignment_actions paa
340: where CONTEXT.run_result_id = RR.run_result_id

Line 483: FROM pay_input_values_f

479: p_effective_date DATE)
480: IS
481: SELECT substr(uom,1,1) uom,
482: name
483: FROM pay_input_values_f
484: WHERE input_value_id = p_input_value_id
485: AND p_effective_date BETWEEN effective_start_date
486: AND effective_end_date;
487:

Line 524: l_uom pay_input_values_f.uom%TYPE;

520:
521: l_latest_assignment_action_id NUMBER;
522: l_run_value NUMBER:=0;/*Bug 3228928*/
523: l_sum_value NUMBER:=0;
524: l_uom pay_input_values_f.uom%TYPE;
525: l_action_info_id NUMBER;
526: l_ovn NUMBER;
527: l_element_name pay_element_types_f.reporting_name%TYPE;
528: l_input_name pay_input_values_f.name%TYPE;

Line 528: l_input_name pay_input_values_f.name%TYPE;

524: l_uom pay_input_values_f.uom%TYPE;
525: l_action_info_id NUMBER;
526: l_ovn NUMBER;
527: l_element_name pay_element_types_f.reporting_name%TYPE;
528: l_input_name pay_input_values_f.name%TYPE;
529: l_element_archived VARCHAR2(1);
530:
531: BEGIN
532: g_debug := hr_utility.debug_enabled;