APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on AR_GTA_SYSTEM_PARAMETERS_ALL

Line 2376: FROM ar_gta_system_parameters_all s

2372: x_succ:=TRUE;
2373: BEGIN
2374: SELECT s.auto_batch_numbering_flag
2375: INTO l_batch_numbering_flag
2376: FROM ar_gta_system_parameters_all s
2377: WHERE s.org_id=P_ORG_ID;
2378: EXCEPTION
2379: WHEN NO_DATA_FOUND THEN
2380: fnd_message.SET_NAME('AR','AR_GTA_SYS_CONFIG_MISSING');

Line 3562: l_currency_code AR_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;

3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:
3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3562: l_currency_code AR_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3563: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;

Line 3988: AR_GTA_SYSTEM_PARAMETERS_ALL

3984: GT_CURRENCY_CODE
3985: INTO
3986: l_currency_code
3987: FROM
3988: AR_GTA_SYSTEM_PARAMETERS_ALL
3989: WHERE
3990: org_id = p_org_id;
3991:
3992: EXCEPTION