DBA Data[Home] [Help]

APPS.PAY_LIV_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 517: l_input_currency_code pay_element_types_f.input_currency_code%type;

513: l_unformatted_value varchar2(255) := p_unformatted_value;
514: l_database_value varchar2(80);
515: l_min_max_failure varchar2(1);
516: l_checkformat_error boolean;
517: l_input_currency_code pay_element_types_f.input_currency_code%type;
518: l_message_text hr_lookups.meaning%type;
519: l_uom pay_input_values_f.uom%type;
520: --
521: Cursor C_currency_uom

Line 524: from pay_element_types_f pet,

520: --
521: Cursor C_currency_uom
522: is
523: select pet.input_currency_code, piv.uom
524: from pay_element_types_f pet,
525: pay_input_values_f piv
526: where pet.element_type_id = piv.element_type_id
527: and piv.input_value_id = p_input_value_id
528: and p_effective_date between pet.effective_start_date