DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_RULE_DFFS_ALL

Line 1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;

1430: l_parameter_prefix VARCHAR2(10) := ':flex';
1431: l_parameter_suffix NUMBER;
1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS

Line 1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;

1431: l_parameter_suffix NUMBER;
1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value

Line 1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;

1432:
1433: l_include_flag VARCHAR2(5);
1434: l_CONTEXT_CODE AR_GTA_RULE_DFFS_ALL.Context_Code%TYPE;
1435: l_ATTRIBUTE_COLUMN AR_GTA_RULE_DFFS_ALL.Attribute_Column%TYPE;
1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value
1440: FROM AR_GTA_RULE_DFFS_ALL l

Line 1440: FROM AR_GTA_RULE_DFFS_ALL l

1436: l_ATTRIBUTE_value AR_GTA_RULE_DFFS_ALL.Attribute_Value%TYPE;
1437:
1438: CURSOR flex_cond_i IS
1439: SELECT l.context_code, l.attribute_column, l.attribute_value
1440: FROM AR_GTA_RULE_DFFS_ALL l
1441: WHERE l.org_id = P_ORG_ID
1442: AND l.rule_header_id = p_transfer_id
1443: AND l.condition_rule = 'I';
1444:

Line 1447: FROM ar_gta_rule_dffs_all l

1443: AND l.condition_rule = 'I';
1444:
1445: CURSOR flex_cond_e IS
1446: SELECT l.context_code, l.attribute_column, l.attribute_value
1447: FROM ar_gta_rule_dffs_all l
1448: WHERE l.Org_Id = P_ORG_ID
1449: AND l.rule_header_id = p_transfer_id
1450: AND l.condition_rule = 'E';
1451: