APPS.PAY_BALANCE_UPLOAD dependencies on FF_CONTEXTS

Line 343: context_name ff_contexts.context_name%type,

339: index by binary_integer;
340:
341: type t_inpval_context_rec is record
342: (
343: context_name ff_contexts.context_name%type,
344: input_value_id pay_input_values_f.input_value_id%type
345: );
346: type t_inpval_context_tab is table of t_inpval_context_rec
347: index by binary_integer;

Line 2291: ,(select context_id from ff_contexts where context_name = 'SOURCE_ID')

2287: ,CONTEXT_VALUE)
2288: VALUES
2289: (l_assignment_action_id
2290: ,p_asg_id
2291: ,(select context_id from ff_contexts where context_name = 'SOURCE_ID')
2292: ,l_reporting_unit_id);
2293: commit;
2294: p_message := 'Insert Record in pay_action_contexts successfully';
2295: EXCEPTION

Line 3336: ,ff_contexts CO

3332: BD.database_item_suffix,
3333: BD.legislation_code
3334: from pay_balance_dimensions BD
3335: ,ff_route_context_usages CU
3336: ,ff_contexts CO
3337: where BD.balance_dimension_id = p_balance_dimension_id
3338: and CU.route_id = BD.route_id
3339: and CO.context_id = CU.context_id;
3340: --

Line 3456: from ff_contexts

3452: --
3453: cursor csr_get_context_id (p_cxt_name in varchar)
3454: is
3455: select context_id
3456: from ff_contexts
3457: where context_name = p_cxt_name;
3458: --
3459: --
3460: l_defined_bal number;

Line 4012: l_context ff_contexts.context_name%type;

4008: --
4009: l_iv_start_ptr number;
4010: l_iv_end_ptr number;
4011: l_iv_idx number;
4012: l_context ff_contexts.context_name%type;
4013: --
4014: begin
4015: --
4016: hr_utility.trace('Entering pay_balance_upload.validate_dimension');