APPS.ARP_APP_CALC_PKG dependencies on AR_APP_RULES

Line 1218: from ar_app_rules

1214: where rule_set_id = p_rule_set_id;
1215:
1216: cursor all_application_blocks is
1217: select rule_name, rule_id,rule_sequence
1218: from ar_app_rules
1219: where rule_set_id = p_rule_set_id
1220: order by rule_sequence;
1221:
1222: cursor application_block is

Line 1224: from ar_app_rules

1220: order by rule_sequence;
1221:
1222: cursor application_block is
1223: select rule_name, rule_id,rule_sequence
1224: from ar_app_rules
1225: where rule_set_id = p_rule_set_id
1226: and overapp_flag = 'N'
1227: order by rule_sequence;
1228:

Line 1231: from ar_app_rules

1227: order by rule_sequence;
1228:
1229: cursor over_application_block is
1230: select rule_name, rule_id,rule_sequence
1231: from ar_app_rules
1232: where rule_set_id = p_rule_set_id
1233: and overapp_flag = 'Y' ;
1234:
1235: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is

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

1231: from ar_app_rules
1232: where rule_set_id = p_rule_set_id
1233: and overapp_flag = 'Y' ;
1234:
1235: cursor all_block (p_rule_id in ar_app_rules.rule_id%TYPE) is
1236: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1237: from ar_app_rule_details
1238: where rule_id = p_rule_id ;
1239:

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

1236: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1237: from ar_app_rule_details
1238: where rule_id = p_rule_id ;
1239:
1240: cursor round_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1241: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1242: from ar_app_rule_details
1243: where rule_id = p_rule_id
1244: and rounding_correction_flag = 'Y';

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

1242: from ar_app_rule_details
1243: where rule_id = p_rule_id
1244: and rounding_correction_flag = 'Y';
1245:
1246: cursor other_block (p_rule_id in ar_app_rules.rule_id%TYPE ) is
1247: select rule_detail_id , line_type , rounding_correction_flag , tax_treatment
1248: from ar_app_rule_details
1249: where rule_id = p_rule_id
1250: and rounding_correction_flag <> 'Y';