92: ,max(decode(global_name,'QE_MONTHLY_LT', global_value ,null)) QE_MONTHLY_LT
93: ,max(decode(global_name,'QE_QUARTERLY_LT', global_value ,null)) QE_QUARTERLY_LT
94: ,max(decode(global_name,'QE_SEMIYEAR_LT', global_value ,null)) QE_SEMIYEAR_LT
95: ,max(decode(global_name,'QE_WEEKLY_LT', global_value ,null)) QE_WEEKLY_LT
96: FROM FF_GLOBALS_F FGF
97: WHERE global_name IN ( 'AUTO_ENROL_TRIG_ANNUAL', 'AUTO_ENROL_TRIG_WEEKLY', 'AUTO_ENROL_TRIG_MONTHLY',
98: 'AUTO_ENROL_TRIG_BIWEEK','AUTO_ENROL_TRIG_LUNAR','AUTO_ENROL_TRIG_QUARTERLY',
99: 'AUTO_ENROL_TRIG_SEMIYEAR','QE_ANNUAL_LT','QE_BIWEEK_LT','QE_LUNAR_LT','QE_MONTHLY_LT'
100: ,'QE_QUARTERLY_LT','QE_SEMIYEAR_LT','QE_WEEKLY_LT')
261: l_employer_name VARCHAR2(150):= NULL;
262: l_employee_name per_all_people_f.full_name%type:= NULL;
263: l_email_address per_all_people_f.email_address%type:= NULL;
264: l_period pay_payrolls_f.period_type%type:= NULL;
265: l_earning ff_globals_f.global_value%type:= NULL;
266: l_earning_lower ff_globals_f.global_value%type:= NULL;
267:
268: l_contact_mail_org VARCHAR2(150) := NULL;
269: l_more_info VARCHAR2(150) := NULL;
262: l_employee_name per_all_people_f.full_name%type:= NULL;
263: l_email_address per_all_people_f.email_address%type:= NULL;
264: l_period pay_payrolls_f.period_type%type:= NULL;
265: l_earning ff_globals_f.global_value%type:= NULL;
266: l_earning_lower ff_globals_f.global_value%type:= NULL;
267:
268: l_contact_mail_org VARCHAR2(150) := NULL;
269: l_more_info VARCHAR2(150) := NULL;
270: l_instruction VARCHAR2(150) := NULL;
1203: --------------------------------------
1204: l_employer_name VARCHAR2(150):= NULL;
1205: l_employee_name per_all_people_f.full_name%type:= NULL;
1206: l_period pay_payrolls_f.period_type%type:= NULL;
1207: l_earning ff_globals_f.global_value%type:= NULL;
1208: l_earning_lower ff_globals_f.global_value%type:= NULL;
1209:
1210: l_contact_mail_org VARCHAR2(32767) := NULL;
1211: l_more_info VARCHAR2(32767) := NULL;
1204: l_employer_name VARCHAR2(150):= NULL;
1205: l_employee_name per_all_people_f.full_name%type:= NULL;
1206: l_period pay_payrolls_f.period_type%type:= NULL;
1207: l_earning ff_globals_f.global_value%type:= NULL;
1208: l_earning_lower ff_globals_f.global_value%type:= NULL;
1209:
1210: l_contact_mail_org VARCHAR2(32767) := NULL;
1211: l_more_info VARCHAR2(32767) := NULL;
1212: l_instruction VARCHAR2(32767) := NULL;