DBA Data[Home] [Help]

APPS.PAY_FRR_BUS dependencies on FF_FDI_USAGES_F

Line 615: from ff_fdi_usages_f fdu

611: --
612: Cursor c_chk_result_name
613: is
614: select null
615: from ff_fdi_usages_f fdu
616: ,pay_status_processing_rules_f spr
617: where spr.status_processing_rule_id = p_status_processing_rule_id
618: and fdu.formula_id = spr.formula_id
619: and fdu.usage in ('O', 'B')

Line 952: l_op_datatype ff_fdi_usages_f.data_type%type;

948: ) is
949: --
950: l_proc varchar2(72) := g_package||'chk_input_value_id';
951: l_uom pay_input_values_f.uom%type;
952: l_op_datatype ff_fdi_usages_f.data_type%type;
953: --
954: Cursor c_chk_input_value is
955: select uom
956: from pay_input_values_f piv

Line 964: from ff_fdi_usages_f fdu

960: and piv.effective_end_date;
961: --
962: Cursor c_result_dtype is
963: select fdu.data_type
964: from ff_fdi_usages_f fdu
965: ,pay_status_processing_rules_f spr
966: where spr.status_processing_rule_id = p_status_processing_rule_id
967: and fdu.formula_id = spr.formula_id
968: and fdu.usage in ('O', 'B')