APPS.IBY_PAYGROUP_PUB dependencies on IBY_PAYMENT_PROFILES

Line 686: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

682: l_pmt_reason_flag VARCHAR2(1) := 'N';
683: l_due_date_flag VARCHAR2(1) := 'N';
684: l_prom_note_flag VARCHAR2(1) := 'N';
685:
686: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
687:
688: /*
689: * Used to substitute null values in date comparisons.
690: * It is assumed that year 5100 = doomsday.

Line 1026: IBY_PAYMENT_PROFILES ppf,

1022: docs.ext_inv_payee_id
1023: /*TPP-Start*/
1024: FROM IBY_DOCS_PAYABLE_ALL docs,
1025: IBY_PMT_CREATION_RULES pcr,
1026: IBY_PAYMENT_PROFILES ppf,
1027: IBY_PAY_SERVICE_REQUESTS prq,
1028: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1029: IBY_PAYMENT_METHODS_B pmt_mthd,
1030: CE_BANK_ACCOUNTS iba

Line 3934: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

3930: || '.performCentralBankReporting';
3931: l_pmt_fx_amount iby_payments_all.payment_amount%TYPE := -1;
3932: l_return_status VARCHAR2(200);
3933: l_declare_flag VARCHAR2(1);
3934: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
3935:
3936: BEGIN
3937:
3938: print_debuginfo(l_module_name, 'ENTER');

Line 4366: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;

4362: l_error_code VARCHAR2(100);
4363: l_error_msg VARCHAR2(500);
4364: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
4365:
4366: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%type;
4367: l_disabled_ppp VARCHAR2(1) := 'N';
4368: BEGIN
4369:
4370: print_debuginfo(l_module_name, 'ENTER');

Line 7279: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;

7275: l_successDocCountTab successDocsCountPerPmtTab;
7276:
7277: /* maps profile ids to system profile codes */
7278: l_profile_map IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType;
7279: l_profile_code IBY_PAYMENT_PROFILES.system_profile_code%TYPE;
7280:
7281: /*
7282: * Remittance advices cursor -- Only pick those
7283: * records that have the format attched... there

Line 11321: IBY_PAYMENT_PROFILES prof

11317: prof.declaration_currency_code,
11318: prof.declaration_threshold_amount
11319: FROM
11320: IBY_PAYMENTS_ALL pmt,
11321: IBY_PAYMENT_PROFILES prof
11322: WHERE
11323: pmt.payment_id = p_payment_id AND
11324: pmt.payment_profile_id = prof.payment_profile_id
11325: ;

Line 11851: IBY_PAYMENT_PROFILES prof,

11847: /* Payment related */
11848: IBY_PAYMENTS_ALL pmt,
11849:
11850: /* Profile related */
11851: IBY_PAYMENT_PROFILES prof,
11852:
11853: /* Payer */
11854: XLE_FIRSTPARTY_INFORMATION_V payer,
11855: HZ_PARTIES payer_party,

Line 12994: IBY_PAYMENT_PROFILES prof,

12990: /* Payment related */
12991: IBY_PAYMENTS_ALL pmt,
12992:
12993: /* Profile related */
12994: IBY_PAYMENT_PROFILES prof,
12995:
12996: /* Payer */
12997: XLE_FIRSTPARTY_INFORMATION_V payer,
12998: HZ_PARTIES payer_party,