APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_RULE_DFFS_ALL

Line 1398: l_CONTEXT_CODE JMF_GTA_RULE_DFFS_ALL.Context_Code%TYPE;

1394: l_parameter_prefix VARCHAR2(10) := ':flex';
1395: l_parameter_suffix NUMBER;
1396:
1397: l_include_flag VARCHAR2(5);
1398: l_CONTEXT_CODE JMF_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1399: l_ATTRIBUTE_COLUMN JMF_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1400: l_ATTRIBUTE_value JMF_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1401:
1402: CURSOR flex_cond_i IS

Line 1399: l_ATTRIBUTE_COLUMN JMF_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;

1395: l_parameter_suffix NUMBER;
1396:
1397: l_include_flag VARCHAR2(5);
1398: l_CONTEXT_CODE JMF_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1399: l_ATTRIBUTE_COLUMN JMF_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1400: l_ATTRIBUTE_value JMF_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1401:
1402: CURSOR flex_cond_i IS
1403: SELECT l.context_code, l.attribute_column, l.attribute_value

Line 1400: l_ATTRIBUTE_value JMF_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;

1396:
1397: l_include_flag VARCHAR2(5);
1398: l_CONTEXT_CODE JMF_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1399: l_ATTRIBUTE_COLUMN JMF_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1400: l_ATTRIBUTE_value JMF_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1401:
1402: CURSOR flex_cond_i IS
1403: SELECT l.context_code, l.attribute_column, l.attribute_value
1404: FROM JMF_GTA_RULE_DFFS_ALL l

Line 1404: FROM JMF_GTA_RULE_DFFS_ALL l

1400: l_ATTRIBUTE_value JMF_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1401:
1402: CURSOR flex_cond_i IS
1403: SELECT l.context_code, l.attribute_column, l.attribute_value
1404: FROM JMF_GTA_RULE_DFFS_ALL l
1405: WHERE l.org_id = P_ORG_ID
1406: AND l.rule_header_id = p_transfer_id
1407: AND l.condition_rule = 'I';
1408:

Line 1411: FROM jmf_gta_rule_dffs_all l

1407: AND l.condition_rule = 'I';
1408:
1409: CURSOR flex_cond_e IS
1410: SELECT l.context_code, l.attribute_column, l.attribute_value
1411: FROM jmf_gta_rule_dffs_all l
1412: WHERE l.Org_Id = P_ORG_ID
1413: AND l.rule_header_id = p_transfer_id
1414: AND l.condition_rule = 'E';
1415: