DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on PAY_ORG_PAYMENT_METHODS_F_TL

Line 3673: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,

3669:
3670: cursor c_get_opm_name ( cp_opmid number,
3671: cp_bgid number) is
3672: select OPMTL.ORG_PAYMENT_METHOD_NAME
3673: from PAY_ORG_PAYMENT_METHODS_F_TL OPMTL,
3674: PAY_ORG_PAYMENT_METHODS_F OPM
3675: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
3676: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
3677: AND BUSINESS_GROUP_ID + 0 = cp_bgid;

Line 3679: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;

3675: where OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
3676: AND OPM.ORG_PAYMENT_METHOD_ID = cp_opmid
3677: AND BUSINESS_GROUP_ID + 0 = cp_bgid;
3678:
3679: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F_TL.ORG_PAYMENT_METHOD_NAME%TYPE;
3680: Begin
3681: l_payment_method_name := null;
3682:
3683: open c_get_opm_name(p_org_payment_method_id,p_business_group_id);