APPS.PAY_SG_DEDUCTIONS dependencies on FF_GLOBALS_F

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

1153: and pbt.balance_type_id = pdb.balance_type_id
1154: and pdb.balance_dimension_id = pbd.balance_dimension_id
1155: and pdb.legislation_code = 'SG';
1156: --
1157: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
1158: is
1159: select global_value, effective_start_date
1160: from ff_globals_f
1161: where global_name = 'CPF_ORD_MONTH_CAP_AMT'

Line 1160: from ff_globals_f

1156: --
1157: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
1158: is
1159: select global_value, effective_start_date
1160: from ff_globals_f
1161: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1162: and p_date between effective_start_date and effective_end_date;
1163:
1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

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

1363: and pbt.balance_type_id = pdb.balance_type_id
1364: and pdb.balance_dimension_id = pbd.balance_dimension_id
1365: and pdb.legislation_code = 'SG';
1366: --
1367: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
1368: is
1369: select global_value, effective_start_date
1370: from ff_globals_f
1371: where global_name = 'CPF_ORD_MONTH_CAP_AMT'

Line 1370: from ff_globals_f

1366: --
1367: cursor c_globals (p_date in ff_globals_f.effective_start_date%type)
1368: is
1369: select global_value, effective_start_date
1370: from ff_globals_f
1371: where global_name = 'CPF_ORD_MONTH_CAP_AMT'
1372: and p_date between effective_start_date and effective_end_date;
1373: --
1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;