APPS.BEN_TCS_COMPENSATION dependencies on PAY_INPUT_VALUES_F

Line 447: pay_input_values_f pi

443: per_bf_processed_assignments pa,
444: per_bf_balance_amounts ba,
445: per_bf_payroll_runs pr,
446: pay_element_types_f pe,
447: pay_input_values_f pi
448: where
449: pa.assignment_id = p_assignment_id
450: and pa.payroll_run_id = pr.payroll_run_id
451: and bt.input_value_id = p_input_value_id

Line 520: pay_input_values_f pivf,

516: pay_payroll_actions ppa,
517: pay_payroll_actions ppa2,
518: pay_run_results ppr,
519: pay_costs pc,
520: pay_input_values_f pivf,
521: pay_element_types_f petf ,
522: pay_element_classifications_vl pec
523: WHERE paaf.assignment_id = paa2.assignment_id
524: AND paa2.assignment_id = paa.assignment_id

Line 628: from pay_input_values_f inv, pay_element_types_f elm

624: elm.element_type_id element_type_id,
625: elm.processing_type processing_type,
626: elm.INPUT_CURRENCY_CODE inp_cur_code,
627: inv.uom uom , inv.lookup_type ,inv.value_set_id
628: from pay_input_values_f inv, pay_element_types_f elm
629: where elm.element_type_id = inv.element_type_id
630: and inv.input_value_id = p_item_key
631: and inv.effective_start_date <= p_effective_date
632: and inv.effective_end_date >= p_period_start_date

Line 1013: l_uom pay_input_values_f.uom%type;

1009: l_value_set_id varchar2(240);
1010: l_actual_currency_code varchar2(30);
1011: l_el_curr_cd pay_element_types_f.input_currency_code%type;
1012: l_summary period_table;
1013: l_uom pay_input_values_f.uom%type;
1014: l_proc varchar2(60) := g_package||'get_value_for_item';
1015: l_actual_uom pay_input_values_f.uom%type;
1016:
1017: begin

Line 1015: l_actual_uom pay_input_values_f.uom%type;

1011: l_el_curr_cd pay_element_types_f.input_currency_code%type;
1012: l_summary period_table;
1013: l_uom pay_input_values_f.uom%type;
1014: l_proc varchar2(60) := g_package||'get_value_for_item';
1015: l_actual_uom pay_input_values_f.uom%type;
1016:
1017: begin
1018: hr_utility.set_location('Entering'||l_proc,10);
1019: hr_utility.set_location('For Person '||p_person_id,499);