APPS.IGIRRPI dependencies on RA_RULES

Line 343: FROM ra_rules

339: -- -----------------------------------------------------------------------------
340: FUNCTION Get_invoicing_Rule (fp_name in varchar2) return NUMBER IS
341: CURSOR c_rule IS
342: SELECT rule_id
343: FROM ra_rules
344: WHERE rule_id IN (-2,-3)
345: AND type = 'I'
346: AND UPPER(name) LIKE UPPER(fp_name)||'%'; -- Bug 2413794 vgadde added UPPER both sides
347: l_rule c_rule%ROWTYPE;

Line 1944: from ra_rules

1940: FUNCTION IsVariableRule ( fp_rule_id in number)
1941: return BOOLEAN IS
1942: CURSOR c_var is
1943: select 'x'
1944: from ra_rules
1945: where rule_id = fp_rule_id
1946: and type = 'ACC_DUR'
1947: ;
1948: BEGIN