APPS.PAY_US_GARN_FEE_RULES_F_PKG dependencies on PAY_US_GARN_FEE_RULES_S
Line 26: CURSOR C2 IS SELECT pay_us_garn_fee_rules_s.nextval FROM sys.dual;
22: X_Creation_Date DATE
23: ) IS
24: CURSOR C IS SELECT rowid FROM PAY_US_GARN_FEE_RULES_F
25: WHERE fee_rule_id = X_Fee_Rule_Id; 26: CURSOR C2 IS SELECT pay_us_garn_fee_rules_s.nextval FROM sys.dual; 27: BEGIN
28: if (X_Fee_Rule_Id is NULL) then
29: OPEN C2;
30: FETCH C2 INTO X_Fee_Rule_Id;