DBA Data[Home] [Help]

APPS.PA_ALLOC_COPY_RULE_PKG dependencies on DUAL

Line 172: CURSOR C1 is Select pa_alloc_rules_s.nextval from sys.dual;

168: from pa_alloc_resources
169: where rule_id = p_rule_id
170: for update of member_type;
171: --Cursor to get the Rule ID
172: CURSOR C1 is Select pa_alloc_rules_s.nextval from sys.dual;
173: --Initialise the Std Who columns
174: G_created_by number := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
175: G_last_updated_by number := G_created_by;
176: G_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);