DBA Data[Home] [Help]

APPS.PAY_US_GARN_FEE_RULES_F_PKG dependencies on DUAL

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;