DBA Data[Home] [Help]

APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_AUC_BIZRULES

Line 7578: , PON_AUC_BIZRULES pon_auc_bizrules

7574:
7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
7582: EXCEPTION

Line 7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

7575: SELECT
7576: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
7582: EXCEPTION
7583: WHEN No_Data_Found THEN

Line 7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

7577: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
7578: , PON_AUC_BIZRULES pon_auc_bizrules
7579: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
7580: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
7581: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
7582: EXCEPTION
7583: WHEN No_Data_Found THEN
7584: g_is_fed := 'N';
7585: WHEN OTHERS THEN