DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 790: from pay_org_payment_methods_f

786: Begin
787: -- Nacha Org Payment Method Name
788: select ORG_PAYMENT_METHOD_NAME
789: into lv_nacha_pymt_name
790: from pay_org_payment_methods_f
791: where business_group_id = p_business_group_id
792: and org_payment_method_id = p_nacha_payment_method
793: and fnd_date.canonical_to_date(p_date_earned)
794: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 807: from pay_org_payment_methods_f

803: Begin
804: -- Check Org Payment Method Name
805: select ORG_PAYMENT_METHOD_NAME
806: into lv_check_pymt_name
807: from pay_org_payment_methods_f
808: where business_group_id = p_business_group_id
809: and org_payment_method_id = p_check_writer_payment_method
810: and fnd_date.canonical_to_date(p_date_earned)
811: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 823: from pay_org_payment_methods_f

819: Begin
820: -- Pre Org Payment Method Name Override
821: select ORG_PAYMENT_METHOD_NAME
822: into lv_pre_ovr_pymt_name
823: from pay_org_payment_methods_f
824: where business_group_id = p_business_group_id
825: and org_payment_method_id = p_payment_method_override
826: and fnd_date.canonical_to_date(p_date_earned)
827: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;