APPS.PAY_WF_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1058: from pay_org_payment_methods_f

1054: Begin
1055: -- Nacha Org Payment Method Name
1056: select ORG_PAYMENT_METHOD_NAME
1057: into lv_nacha_pymt_name
1058: from pay_org_payment_methods_f
1059: where business_group_id = p_business_group_id
1060: and org_payment_method_id = p_nacha_payment_method
1061: and fnd_date.canonical_to_date(p_date_earned)
1062: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 1075: from pay_org_payment_methods_f

1071: Begin
1072: -- Check Org Payment Method Name
1073: select ORG_PAYMENT_METHOD_NAME
1074: into lv_check_pymt_name
1075: from pay_org_payment_methods_f
1076: where business_group_id = p_business_group_id
1077: and org_payment_method_id = p_check_writer_payment_method
1078: and fnd_date.canonical_to_date(p_date_earned)
1079: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 1091: from pay_org_payment_methods_f

1087: Begin
1088: -- Pre Org Payment Method Name Override
1089: select ORG_PAYMENT_METHOD_NAME
1090: into lv_pre_ovr_pymt_name
1091: from pay_org_payment_methods_f
1092: where business_group_id = p_business_group_id
1093: and org_payment_method_id = p_payment_method_override
1094: and fnd_date.canonical_to_date(p_date_earned)
1095: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 2781: from pay_org_payment_methods_f

2777: Begin
2778: -- Nacha Org Payment Method Name
2779: select ORG_PAYMENT_METHOD_NAME
2780: into lv_nacha_pymt_name
2781: from pay_org_payment_methods_f
2782: where business_group_id = p_business_group_id
2783: and org_payment_method_id = p_nacha_payment_method
2784: and fnd_date.canonical_to_date(p_date_earned)
2785: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 2798: from pay_org_payment_methods_f

2794: Begin
2795: -- Check Org Payment Method Name
2796: select ORG_PAYMENT_METHOD_NAME
2797: into lv_check_pymt_name
2798: from pay_org_payment_methods_f
2799: where business_group_id = p_business_group_id
2800: and org_payment_method_id = p_check_writer_payment_method
2801: and fnd_date.canonical_to_date(p_date_earned)
2802: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line 2814: from pay_org_payment_methods_f

2810: Begin
2811: -- Pre Org Payment Method Name Override
2812: select ORG_PAYMENT_METHOD_NAME
2813: into lv_pre_ovr_pymt_name
2814: from pay_org_payment_methods_f
2815: where business_group_id = p_business_group_id
2816: and org_payment_method_id = p_payment_method_override
2817: and fnd_date.canonical_to_date(p_date_earned)
2818: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;