DBA Data[Home] [Help]

APPS.PAY_YREND_REPORTS_PKG dependencies on FF_CONTEXTS

Line 197: select context_id from ff_contexts

193: l_start_date pay_payroll_actions.start_date%TYPE;
194:
195: -- BUG2538173
196: CURSOR c_state_context (p_context_name varchar2) is
197: select context_id from ff_contexts
198: where context_name = p_context_name;
199:
200: l_state_code pay_us_states.state_code%type;
201: l_locality_code varchar2(20);

Line 206: l_tuid_context ff_contexts.context_id%TYPE;

202:
203: TYPE RefCurType is REF CURSOR;
204: c_actions_with_state RefCurType;
205: c_actions_with_state_sql varchar2(10000);
206: l_tuid_context ff_contexts.context_id%TYPE;
207: l_juri_context ff_contexts.context_id%TYPE;
208:
209: CURSOR c_state_ueid (p_user_entity_name varchar2) is
210: select user_entity_id

Line 207: l_juri_context ff_contexts.context_id%TYPE;

203: TYPE RefCurType is REF CURSOR;
204: c_actions_with_state RefCurType;
205: c_actions_with_state_sql varchar2(10000);
206: l_tuid_context ff_contexts.context_id%TYPE;
207: l_juri_context ff_contexts.context_id%TYPE;
208:
209: CURSOR c_state_ueid (p_user_entity_name varchar2) is
210: select user_entity_id
211: from ff_user_entities