APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 144: FROM pay_input_values_f piv,

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

Line 145: pay_input_values_f_tl pivtl

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

Line 156: l_uom pay_input_values_f.uom%TYPE;

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

Line 164: l_input_value_name pay_input_values_f.name%TYPE;

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

Line 338: ,pay_input_values_f PIVF

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

Line 485: FROM pay_input_values_f

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

Line 526: l_uom pay_input_values_f.uom%TYPE;

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

Line 530: l_input_name pay_input_values_f.name%TYPE;

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