eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on DUAL

Line 3792: FROM DUAL;

3788:
3789: BEGIN
3790:
3791: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID
3792: FROM DUAL;
3793:
3794: END getNextPaymentID;
3795:
3796: /*--------------------------------------------------------------------

Line 3801: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table

Line 3839: * reference individual fields of the PL/SQL record.

3835:
3836: /*
3837: * Update the documents. We cannot use bulk update here
3838: * because the bulk update syntax does not allow us to
3839: * reference individual fields of the PL/SQL record.
3840: *
3841: * By default, set the formatting payment it for a
3842: * document same as it's payment id; the payment
3843: * instruction creation program will update the

Line 7337: * Individual payments contain the profile id

7333:
7334: /*
7335: * Get the mapping between profile ids and system profile codes.
7336: *
7337: * Individual payments contain the profile id
7338: * as an attribute. However, the config tables like
7339: * reit advice setup etc. contain settings
7340: * based on system profile codes.
7341: *

Line 8390: FROM DUAL;

8386: * occurance of an event. Therefore, it should be
8387: * a sequence number.
8388: */
8389: SELECT IBY_EVENT_KEY_S.nextval INTO l_event_key
8390: FROM DUAL;
8391:
8392: IF (p_rej_level = REJ_LVL_REQUEST) THEN
8393:
8394: /*

Line 11715: 'INDIVIDUAL',vendor.individual_1099,

11711: */
11712: decode(upper(vendor.vendor_type_lookup_code),
11713: 'EMPLOYEE', per.national_identifier,
11714: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
11715: 'INDIVIDUAL',vendor.individual_1099,
11716: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
11717: 'PARTNERSHIP',vendor.individual_1099,
11718: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
11719: vendor.num_1099),

Line 11716: 'FOREIGN INDIVIDUAL',vendor.individual_1099,

11712: decode(upper(vendor.vendor_type_lookup_code),
11713: 'EMPLOYEE', per.national_identifier,
11714: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
11715: 'INDIVIDUAL',vendor.individual_1099,
11716: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
11717: 'PARTNERSHIP',vendor.individual_1099,
11718: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
11719: vendor.num_1099),
11720: vendor.num_1099), -- payee Tax Identification Number

Line 11717: 'PARTNERSHIP',vendor.individual_1099,

11713: 'EMPLOYEE', per.national_identifier,
11714: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
11715: 'INDIVIDUAL',vendor.individual_1099,
11716: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
11717: 'PARTNERSHIP',vendor.individual_1099,
11718: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
11719: vendor.num_1099),
11720: vendor.num_1099), -- payee Tax Identification Number
11721:

Line 11718: 'FOREIGN PARTNERSHIP',vendor.individual_1099,

11714: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
11715: 'INDIVIDUAL',vendor.individual_1099,
11716: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
11717: 'PARTNERSHIP',vendor.individual_1099,
11718: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
11719: vendor.num_1099),
11720: vendor.num_1099), -- payee Tax Identification Number
11721:
11722: /* PAYEE BANK */

Line 11802: 'INDIVIDUAL',invvendor.individual_1099,

11798: invpayee.party_name inv_payee_party_name,
11799:
11800: decode(upper(invvendor.vendor_type_lookup_code),
11801: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
11802: 'INDIVIDUAL',invvendor.individual_1099,
11803: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
11804: 'PARTNERSHIP',invvendor.individual_1099,
11805: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
11806: invvendor.num_1099),

Line 11803: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,

11799:
11800: decode(upper(invvendor.vendor_type_lookup_code),
11801: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
11802: 'INDIVIDUAL',invvendor.individual_1099,
11803: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
11804: 'PARTNERSHIP',invvendor.individual_1099,
11805: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
11806: invvendor.num_1099),
11807: invvendor.num_1099) inv_payee_le_reg_num,

Line 11804: 'PARTNERSHIP',invvendor.individual_1099,

11800: decode(upper(invvendor.vendor_type_lookup_code),
11801: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
11802: 'INDIVIDUAL',invvendor.individual_1099,
11803: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
11804: 'PARTNERSHIP',invvendor.individual_1099,
11805: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
11806: invvendor.num_1099),
11807: invvendor.num_1099) inv_payee_le_reg_num,
11808:

Line 11805: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,

11801: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
11802: 'INDIVIDUAL',invvendor.individual_1099,
11803: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
11804: 'PARTNERSHIP',invvendor.individual_1099,
11805: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
11806: invvendor.num_1099),
11807: invvendor.num_1099) inv_payee_le_reg_num,
11808:
11809: IBY_FD_EXTRACT_GEN_PVT.

Line 12859: 'INDIVIDUAL',vendor.individual_1099,

12855: */
12856: decode(upper(vendor.vendor_type_lookup_code),
12857: 'EMPLOYEE', per.national_identifier,
12858: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
12859: 'INDIVIDUAL',vendor.individual_1099,
12860: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
12861: 'PARTNERSHIP',vendor.individual_1099,
12862: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
12863: vendor.num_1099),

Line 12860: 'FOREIGN INDIVIDUAL',vendor.individual_1099,

12856: decode(upper(vendor.vendor_type_lookup_code),
12857: 'EMPLOYEE', per.national_identifier,
12858: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
12859: 'INDIVIDUAL',vendor.individual_1099,
12860: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
12861: 'PARTNERSHIP',vendor.individual_1099,
12862: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
12863: vendor.num_1099),
12864: vendor.num_1099), -- payee Tax Identification Number

Line 12861: 'PARTNERSHIP',vendor.individual_1099,

12857: 'EMPLOYEE', per.national_identifier,
12858: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
12859: 'INDIVIDUAL',vendor.individual_1099,
12860: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
12861: 'PARTNERSHIP',vendor.individual_1099,
12862: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
12863: vendor.num_1099),
12864: vendor.num_1099), -- payee Tax Identification Number
12865:

Line 12862: 'FOREIGN PARTNERSHIP',vendor.individual_1099,

12858: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
12859: 'INDIVIDUAL',vendor.individual_1099,
12860: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
12861: 'PARTNERSHIP',vendor.individual_1099,
12862: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
12863: vendor.num_1099),
12864: vendor.num_1099), -- payee Tax Identification Number
12865:
12866: /* PAYEE BANK */

Line 12946: 'INDIVIDUAL',invvendor.individual_1099,

12942: invpayee.party_name inv_payee_party_name,
12943:
12944: decode(upper(invvendor.vendor_type_lookup_code),
12945: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
12946: 'INDIVIDUAL',invvendor.individual_1099,
12947: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
12948: 'PARTNERSHIP',invvendor.individual_1099,
12949: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
12950: invvendor.num_1099),

Line 12947: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,

12943:
12944: decode(upper(invvendor.vendor_type_lookup_code),
12945: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
12946: 'INDIVIDUAL',invvendor.individual_1099,
12947: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
12948: 'PARTNERSHIP',invvendor.individual_1099,
12949: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
12950: invvendor.num_1099),
12951: invvendor.num_1099) inv_payee_le_reg_num,

Line 12948: 'PARTNERSHIP',invvendor.individual_1099,

12944: decode(upper(invvendor.vendor_type_lookup_code),
12945: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
12946: 'INDIVIDUAL',invvendor.individual_1099,
12947: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
12948: 'PARTNERSHIP',invvendor.individual_1099,
12949: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
12950: invvendor.num_1099),
12951: invvendor.num_1099) inv_payee_le_reg_num,
12952:

Line 12949: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,

12945: 'CONTRACTOR',decode(invvendor.organization_type_lookup_code,
12946: 'INDIVIDUAL',invvendor.individual_1099,
12947: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
12948: 'PARTNERSHIP',invvendor.individual_1099,
12949: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
12950: invvendor.num_1099),
12951: invvendor.num_1099) inv_payee_le_reg_num,
12952:
12953: IBY_FD_EXTRACT_GEN_PVT.