DBA Data[Home] [Help]

APPS.PAY_ORG_PAYMENT_METHODS_PKG dependencies on FND_DATE

Line 1067: and effective_end_date > fnd_date.canonical_to_date(p_end_date);

1063: select null
1064: into l_dummy
1065: from pay_personal_payment_methods_f
1066: where org_payment_method_id = p_opm_id
1067: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1068: if (SQL%FOUND) then
1069: hr_utility.set_message(801, 'HR_6235_PAYM_EXISTING_PPMS');
1070: hr_utility.raise_error;
1071: end if;

Line 1078: and effective_end_date > fnd_date.canonical_to_date(p_end_date);

1074: select null
1075: into l_dummy
1076: from pay_org_pay_method_usages_f
1077: where org_payment_method_id = p_opm_id
1078: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1079: if (SQL%FOUND) then
1080: hr_utility.set_message(801, 'HR_6236_PAYM_USED_AS_DEFAULT');
1081: hr_utility.raise_error;
1082: end if;