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.

APPS.IBY_PAYGROUP_PUB dependencies on DUAL

Line 1022: FROM dual

1018:
1019: BEGIN
1020: SELECT 'Y'
1021: INTO l_calc_jp_bank_charges
1022: FROM dual
1023: WHERE EXISTS (SELECT 1
1024: FROM ap_system_parameters_all asp
1025: , IBY_PAYMENTS_ALL pmt
1026: WHERE pmt.PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id

Line 1053: FROM dual

1049: END IF;
1050: BEGIN
1051: SELECT 'Y'
1052: INTO l_call_ap_awt_callout
1053: FROM dual
1054: WHERE EXISTS (SELECT 1
1055: FROM ap_system_parameters_all asp,
1056: IBY_PAYMENTS_ALL pmt
1057: WHERE pmt.PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id

Line 9353: FROM DUAL;

9349:
9350: BEGIN
9351:
9352: SELECT IBY_PAYMENTS_ALL_S.nextval INTO x_paymentID
9353: FROM DUAL;
9354:
9355: END getNextPaymentID;
9356:
9357: /*--------------------------------------------------------------------

Line 9362: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table

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

9400:
9401: /*
9402: * Update the documents. We cannot use bulk update here
9403: * because the bulk update syntax does not allow us to
9404: * reference individual fields of the PL/SQL record.
9405: *
9406: * By default, set the formatting payment it for a
9407: * document same as it's payment id; the payment
9408: * instruction creation program will update the

Line 9477: | Updates individual documents in IBY_DOCS_PAYABLE_ALL table

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

9498:
9499: /*
9500: * Update the documents. We cannot use bulk update here
9501: * because the bulk update syntax does not allow us to
9502: * reference individual fields of the PL/SQL record.
9503: *
9504: * By default, set the formatting payment it for a
9505: * document same as it's payment id; the payment
9506: * instruction creation program will update the

Line 15910: * Individual payments contain the profile id

15906:
15907: /*
15908: * Get the mapping between profile ids and system profile codes.
15909: *
15910: * Individual payments contain the profile id
15911: * as an attribute. However, the config tables like
15912: * reit advice setup etc. contain settings
15913: * based on system profile codes.
15914: *

Line 16197: * Individual payments contain the profile id

16193:
16194: /*
16195: * Get the mapping between profile ids and system profile codes.
16196: *
16197: * Individual payments contain the profile id
16198: * as an attribute. However, the config tables like
16199: * reit advice setup etc. contain settings
16200: * based on system profile codes.
16201: *

Line 17294: from DUAL

17290:
17291: Begin
17292: SELECT 'N'
17293: INTO l_allsuccess_flag
17294: from DUAL
17295: WHERE EXISTS
17296: (SELECT 1 FROM IBY_PAYMENTS_ALL
17297: WHERE PAYMENT_STATUS NOT IN (PAY_STATUS_CREATED, PAY_STATUS_REMOVED)
17298: AND payment_service_request_id =p_payreq_id

Line 17337: from DUAL

17333:
17334: begin
17335: SELECT 'N'
17336: INTO l_allfailed_flag
17337: from DUAL
17338: WHERE EXISTS
17339: (SELECT 1 FROM IBY_PAYMENTS_ALL
17340: WHERE PAYMENT_STATUS = PAY_STATUS_CREATED
17341: AND payment_service_request_id =p_payreq_id

Line 18675: FROM DUAL;

18671: * occurance of an event. Therefore, it should be
18672: * a sequence number.
18673: */
18674: SELECT IBY_EVENT_KEY_S.nextval INTO l_event_key
18675: FROM DUAL;
18676:
18677: IF (p_rej_level = REJ_LVL_REQUEST) THEN
18678:
18679: /*

Line 24204: 'INDIVIDUAL',vendor.individual_1099,

24200: decode(upper(vendor.vendor_type_lookup_code),
24201: 'EMPLOYEE',null
24202: ,
24203: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
24204: 'INDIVIDUAL',vendor.individual_1099,
24205: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
24206: 'PARTNERSHIP',vendor.individual_1099,
24207: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
24208: vendor.num_1099),

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

24201: 'EMPLOYEE',null
24202: ,
24203: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
24204: 'INDIVIDUAL',vendor.individual_1099,
24205: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
24206: 'PARTNERSHIP',vendor.individual_1099,
24207: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
24208: vendor.num_1099),
24209: vendor.num_1099), -- payee Tax Identification Number

Line 24206: 'PARTNERSHIP',vendor.individual_1099,

24202: ,
24203: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
24204: 'INDIVIDUAL',vendor.individual_1099,
24205: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
24206: 'PARTNERSHIP',vendor.individual_1099,
24207: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
24208: vendor.num_1099),
24209: vendor.num_1099), -- payee Tax Identification Number
24210: vendor_site.attribute_category -- vendor site attr category

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

24203: 'CONTRACTOR',decode(vendor.organization_type_lookup_code,
24204: 'INDIVIDUAL',vendor.individual_1099,
24205: 'FOREIGN INDIVIDUAL',vendor.individual_1099,
24206: 'PARTNERSHIP',vendor.individual_1099,
24207: 'FOREIGN PARTNERSHIP',vendor.individual_1099,
24208: vendor.num_1099),
24209: vendor.num_1099), -- payee Tax Identification Number
24210: vendor_site.attribute_category -- vendor site attr category
24211:

Line 26006: 'INDIVIDUAL',invvendor.individual_1099,

26002: CASE
26003: WHEN (NVL(IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_org_index),-99)>0)
26004: THEN (DECODE(upper(invvendor.vendor_type_lookup_code),
26005: 'CONTRACTOR',DECODE(invvendor.organization_type_lookup_code,
26006: 'INDIVIDUAL',invvendor.individual_1099,
26007: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
26008: 'PARTNERSHIP',invvendor.individual_1099,
26009: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
26010: invvendor.num_1099),

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

26003: WHEN (NVL(IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_org_index),-99)>0)
26004: THEN (DECODE(upper(invvendor.vendor_type_lookup_code),
26005: 'CONTRACTOR',DECODE(invvendor.organization_type_lookup_code,
26006: 'INDIVIDUAL',invvendor.individual_1099,
26007: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
26008: 'PARTNERSHIP',invvendor.individual_1099,
26009: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
26010: invvendor.num_1099),
26011: invvendor.num_1099))

Line 26008: 'PARTNERSHIP',invvendor.individual_1099,

26004: THEN (DECODE(upper(invvendor.vendor_type_lookup_code),
26005: 'CONTRACTOR',DECODE(invvendor.organization_type_lookup_code,
26006: 'INDIVIDUAL',invvendor.individual_1099,
26007: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
26008: 'PARTNERSHIP',invvendor.individual_1099,
26009: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
26010: invvendor.num_1099),
26011: invvendor.num_1099))
26012: ELSE invpayee.jgzz_fiscal_code

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

26005: 'CONTRACTOR',DECODE(invvendor.organization_type_lookup_code,
26006: 'INDIVIDUAL',invvendor.individual_1099,
26007: 'FOREIGN INDIVIDUAL',invvendor.individual_1099,
26008: 'PARTNERSHIP',invvendor.individual_1099,
26009: 'FOREIGN PARTNERSHIP',invvendor.individual_1099,
26010: invvendor.num_1099),
26011: invvendor.num_1099))
26012: ELSE invpayee.jgzz_fiscal_code
26013: END inv_payee_le_reg_num,