[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 ppa,
518: pay_costs pc,
519: pay_run_results prr,
520: pay_input_values_f pivf,
521: pay_element_types_f petf,
522: pay_element_classifications pec
523: WHERE paa.payroll_action_id = ppa.payroll_action_id
524: AND paa.assignment_action_id = pc.assignment_action_id
525: --and paa.assignment_action_id = prr.assignment_action_id
596: Pay_run_result_values prrv,
597: pay_assignment_actions paa,
598: pay_payroll_actions ppa,
599: pay_input_values_f piv,
600: pay_element_types_f pet
601: WHERE paaf.assignment_id = paa.assignment_id
602: AND prr.assignment_action_id = paa.assignment_action_id
603: AND prr.run_result_id=prrv.run_result_id
604: AND paa.PAYROLL_ACTION_ID=ppa.PAYROLL_ACTION_ID
689: elm.element_type_id element_type_id,
690: elm.processing_type processing_type,
691: elm.INPUT_CURRENCY_CODE inp_cur_code,
692: inv.uom uom , inv.lookup_type ,inv.value_set_id
693: from pay_input_values_f inv, pay_element_types_f elm
694: where elm.element_type_id = inv.element_type_id
695: and inv.input_value_id = p_item_key
696: and inv.effective_start_date <= p_effective_date
697: and inv.effective_end_date >= p_period_start_date
1086: l_proc_type varchar2(30);
1087: l_lookup_type varchar2(240);
1088: l_value_set_id varchar2(240);
1089: l_actual_currency_code varchar2(30);
1090: l_el_curr_cd pay_element_types_f.input_currency_code%type;
1091: l_summary period_table;
1092: l_uom pay_input_values_f.uom%type;
1093: l_proc varchar2(60) := g_package||'get_value_for_item';
1094: l_actual_uom pay_input_values_f.uom%type;