APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on IBY_PAYMENTS_ALL

Line 89: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;

85: -- This function will return a 'N' or null value.
86: -- --------------------------------------------------------------------------
87:
88: FUNCTION get_Allotment_Code (p_payment_id IN number) return VARCHAR2 is
89: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;
90: BEGIN
91:
92: if (NOT fv_install.enabled) then
93: return null;

Line 99: from iby_payments_all

95:
96:
97: select payment_reason_code
98: into l_payment_reason_code
99: from iby_payments_all
100: where payment_id = p_payment_id;
101:
102: if (l_payment_reason_code = 'US_FV_S') then
103: return 'N';

Line 125: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;

121: FUNCTION TOP_Offset_Eligibility_Flag (p_payment_id IN number) return VARCHAR2
122: IS
123:
124:
125: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;
126: l_payment_date iby_payments_all.payment_date%TYPE;
127: l_org_id iby_payments_all.org_id%TYPE;
128: l_ledger_id gl_ledgers.ledger_id%TYPE;
129: l_ledger_name gl_ledgers.name%TYPE;

Line 126: l_payment_date iby_payments_all.payment_date%TYPE;

122: IS
123:
124:
125: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;
126: l_payment_date iby_payments_all.payment_date%TYPE;
127: l_org_id iby_payments_all.org_id%TYPE;
128: l_ledger_id gl_ledgers.ledger_id%TYPE;
129: l_ledger_name gl_ledgers.name%TYPE;
130: l_coa gl_ledgers.chart_of_accounts_id%TYPE;

Line 127: l_org_id iby_payments_all.org_id%TYPE;

123:
124:
125: l_payment_reason_code iby_payments_all.payment_reason_code%TYPE;
126: l_payment_date iby_payments_all.payment_date%TYPE;
127: l_org_id iby_payments_all.org_id%TYPE;
128: l_ledger_id gl_ledgers.ledger_id%TYPE;
129: l_ledger_name gl_ledgers.name%TYPE;
130: l_coa gl_ledgers.chart_of_accounts_id%TYPE;
131: l_delimiter VARCHAR2(1);

Line 167: FROM iby_payments_all ipa,

163:
164: CURSOR invoice_dist_csr
165: IS
166: SELECT DISTINCT aid.dist_code_combination_id
167: FROM iby_payments_all ipa,
168: iby_docs_payable_all idpa,
169: ap_invoice_distributions aid
170: WHERE ipa.payment_id = p_payment_id
171: and ipa.payment_id = idpa.payment_id

Line 205: from iby_payments_all

201: -- get the required data from payment_id
202:
203: select payment_reason_code, payment_date, org_id
204: into l_payment_reason_code, l_payment_date, l_org_id
205: from iby_payments_all
206: where payment_id = p_payment_id;
207:
208: mo_utils.get_Ledger_Info
209: (p_operating_unit => l_org_id,

Line 228: from iby_payments_all ipa,

224:
225:
226: select aia.vendor_id, aia.vendor_site_id, aps.vendor_type_lookup_code
227: into l_vendor_id, l_vendor_site_id, l_vendor_type
228: from iby_payments_all ipa,
229: iby_docs_payable_all idpa,
230: ap_invoices_all aia,
231: ap_suppliers aps
232: where ipa.payment_id = p_payment_id