APPS.PAY_SG_AWCAP_ARCHIVE dependencies on FF_GLOBALS_F

Line 233: l_cpf_tot_earn_cap_amt ff_globals_f.global_value%type;

229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
232: l_person_id per_all_people_f.person_id%type;
233: l_cpf_tot_earn_cap_amt ff_globals_f.global_value%type;
234: l_aw_toward_cap number;
235: l_aw_cap_recalculated number;
236: l_master_block char(1);
237: l_over_paid_flag char(1);

Line 315: cursor c_globals(c_effective_date ff_globals_f.effective_start_date%type)

311: and g_pact.end_date
312: and ppa.payroll_action_id = pac.payroll_action_id
313: and pac.action_sequence = c_action_sequence;
314: --
315: cursor c_globals(c_effective_date ff_globals_f.effective_start_date%type)
316: is
317: select global_value
318: from ff_globals_f
319: where global_name = 'CPF_TOT_EARN_CAP_AMT'

Line 318: from ff_globals_f

314: --
315: cursor c_globals(c_effective_date ff_globals_f.effective_start_date%type)
316: is
317: select global_value
318: from ff_globals_f
319: where global_name = 'CPF_TOT_EARN_CAP_AMT'
320: and c_effective_date between effective_start_date and effective_end_date ;
321: --
322: month_year_action_sequence_rec month_year_action_sequence%rowtype;

Line 617: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)

613: and pbt.balance_type_id = pdb.balance_type_id
614: and pdb.balance_dimension_id = pbd.balance_dimension_id
615: and pdb.legislation_code = 'SG';
616: --
617: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
618: is
619: select global_value, effective_start_date
620: from ff_globals_f
621: where global_name = 'CPF_ORD_MONTH_CAP_AMT'

Line 620: from ff_globals_f

616: --
617: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
618: is
619: select global_value, effective_start_date
620: from ff_globals_f
621: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
622: and p_date between effective_start_date and effective_end_date;
623:
624: --