DBA Data[Home] [Help]

APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on FV_OPERATING_UNITS_ALL

Line 25: l_fed_employer_number fv_operating_units_all.fed_employer_id_number%TYPE;

21: --
22: -- --------------------------------------------------------------------------
23: FUNCTION get_FEIN (p_payment_instruction_id IN number) return VARCHAR2 is
24:
25: l_fed_employer_number fv_operating_units_all.fed_employer_id_number%TYPE;
26:
27: BEGIN
28: if (NOT fv_install.enabled) then
29: return null;

Line 34: from fv_operating_units_all foua,

30: end if;
31:
32: select fed_employer_id_number
33: into l_fed_employer_number
34: from fv_operating_units_all foua,
35: iby_pay_instructions_all ipia
36: where ipia.payment_instruction_id = p_payment_instruction_id
37: and ipia.org_id = foua.org_id;
38: