[Home] [Help]
442: per_bf_balance_types bt,
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
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
525: AND paa2.payroll_action_id = ppa2.payroll_action_id
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
1007: l_proc_type varchar2(30);
1008: l_lookup_type varchar2(240);
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;