APPS.PAY_FR_ARC_PKG dependencies on FF_CONTEXTS

Line 93: g_source_text ff_contexts.context_id%TYPE;

89: g_fr_name_start_date fnd_lookup_values.meaning%TYPE;
90: g_fr_name_end_date fnd_lookup_values.meaning%TYPE;
91: --
92: --
93: g_source_text ff_contexts.context_id%TYPE;
94: --
95: -- To hold termination element id - special processing for termination
96: --
97: g_term_ele_subject_to_ss pay_element_types_f.element_Type_id%TYPE;

Line 272: from ff_contexts

268: p_payroll_action_id in number) is
269: --
270: cursor csr_context(p_name varchar2) is
271: select context_id
272: from ff_contexts
273: where context_name = p_name;
274: --
275: -- Get the element_type_ids of the termination elements
276: --

Line 352: -- Get the context id of SOURCE_TEXT in ff_contexts

348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);
351: --
352: -- Get the context id of SOURCE_TEXT in ff_contexts
353: --
354: open csr_context('SOURCE_TEXT');
355: fetch csr_context INTO g_source_text;
356: close csr_context;