DBA Data[Home] [Help]

APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_BIZRULES

Line 1071: , PON_AUC_BIZRULES pon_auc_bizrules

1067:
1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1075: EXCEPTION

Line 1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

1068: SELECT
1069: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed
1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1075: EXCEPTION
1076: WHEN No_Data_Found THEN

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

1070: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
1071: , PON_AUC_BIZRULES pon_auc_bizrules
1072: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
1073: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
1074: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
1075: EXCEPTION
1076: WHEN No_Data_Found THEN
1077: l_is_fed := 'N';
1078: WHEN OTHERS THEN