DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on PAY_ORG_PAYMENT_METHODS_F_TL

Line 4009: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,

4005:
4006: cursor c_get_opm_name ( cp_opmid number,
4007: cp_bgid number) is
4008: select OPMTL.ORG_PAYMENT_METHOD_NAME
4009: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
4010: PAY_ORG_PAYMENT_METHODS_F OPM
4011: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
4012: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
4013: AND BUSINESS_GROUP_ID + 0 = cp_bgid

Line 4016: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;

4012: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
4013: AND BUSINESS_GROUP_ID + 0 = cp_bgid
4014: AND OPMTL.LANGUAGE = USERENV('LANG');
4015:
4016: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;
4017: Begin
4018: l_payment_method_name := null;
4019:
4020: open c_get_opm_name(p_org_payment_method_id,p_business_group_id);