DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 1024: FROM ap_system_parameters_all asp

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
1027: AND pmt.org_id = asp.org_id
1028: AND nvl(asp.use_bank_charge_flag,'N') = 'Y');

Line 1055: FROM ap_system_parameters_all asp,

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
1058: AND pmt.org_id = asp.org_id
1059: AND nvl(asp.allow_awt_flag,'N') = 'Y');