DBA Data[Home] [Help]

APPS.PSA_MFAR_UTILS dependencies on PSA_MF_ACCOUNT_MAPPING_ALL

Line 810: PSA_MF_ACCOUNT_MAPPING_ALL B

806: CURSOR c_mapped_account (c_lookup_code IN VARCHAR2,
807: c_source_account IN VARCHAR2) IS
808: SELECT b.target_account mapped_account
809: FROM PSA_MF_ACCT_MAP_HEADER_ALL A,
810: PSA_MF_ACCOUNT_MAPPING_ALL B
811: WHERE a.psa_acct_mapping_id = b.psa_acct_mapping_id
812: AND a.org_id = l_org_id
813: AND a.document_code = p_transaction_type
814: AND a.lookup_code = c_lookup_code

Line 820: l_mapped_account PSA_MF_ACCOUNT_MAPPING_ALL.target_account%TYPE;

816: AND trunc(sysdate) >= trunc(b.start_date_active)
817: AND trunc(sysdate) <= trunc(nvl(b.end_date_active,sysdate));
818:
819: l_account_code fnd_flex_values.compiled_value_attributes%TYPE;
820: l_mapped_account PSA_MF_ACCOUNT_MAPPING_ALL.target_account%TYPE;
821:
822: -- ========================= FND LOG ===========================
823: l_full_path VARCHAR2(100) := g_path || 'get_mapped_account';
824: -- ========================= FND LOG ===========================