APPS.ARP_APP_CALC_PKG dependencies on AR_APP_RULES

Line 1228: from ar_app_rules

1224: where rule_set_id = p_rule_set_id;
1225:
1226: cursor all_application_blocks is
1227: select rule_name, rule_id,rule_sequence
1228: from ar_app_rules
1229: where rule_set_id = p_rule_set_id
1230: order by rule_sequence;
1231:
1232: cursor application_block is

Line 1234: from ar_app_rules

1230: order by rule_sequence;
1231:
1232: cursor application_block is
1233: select rule_name, rule_id,rule_sequence
1234: from ar_app_rules
1235: where rule_set_id = p_rule_set_id
1236: and overapp_flag = 'N'
1237: order by rule_sequence;
1238:

Line 1241: from ar_app_rules

1237: order by rule_sequence;
1238:
1239: cursor over_application_block is
1240: select rule_name, rule_id,rule_sequence
1241: from ar_app_rules
1242: where rule_set_id = p_rule_set_id
1243: and overapp_flag = 'Y' ;
1244:
1245: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is

Line 1245: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is

1241: from ar_app_rules
1242: where rule_set_id = p_rule_set_id
1243: and overapp_flag = 'Y' ;
1244:
1245: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is
1246: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1247: from ar_app_rule_details
1248: where rule_id = p_rule_id ;
1249:

Line 1250: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is

1246: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1247: from ar_app_rule_details
1248: where rule_id = p_rule_id ;
1249:
1250: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1251: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1252: from ar_app_rule_details
1253: where rule_id = p_rule_id
1254: and rounding_correction_flag = 'Y';

Line 1256: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is

1252: from ar_app_rule_details
1253: where rule_id = p_rule_id
1254: and rounding_correction_flag = 'Y';
1255:
1256: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1257: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1258: from ar_app_rule_details
1259: where rule_id = p_rule_id
1260: and rounding_correction_flag <> 'Y';