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 933: l_op_datatype ff_fdi_usages_f.data_type%type;

929: ) is
930: --
931: l_proc varchar2(72) := g_package||'chk_input_value_id';
932: l_uom pay_input_values_f.uom%type;
933: l_op_datatype ff_fdi_usages_f.data_type%type;
934: --
935: Cursor c_chk_input_value is
936: select uom
937: from pay_input_values_f piv

Line 945: from ff_fdi_usages_f fdu

941: and piv.effective_end_date;
942: --
943: Cursor c_result_dtype is
944: select fdu.data_type
945: from ff_fdi_usages_f fdu
946: ,pay_status_processing_rules_f spr
947: where spr.status_processing_rule_id = p_status_processing_rule_id
948: and fdu.formula_id = spr.formula_id
949: and fdu.usage in ('O', 'B')