DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on FF_GLOBALS_F

Line 96: FROM FF_GLOBALS_F FGF

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')

Line 265: l_earning ff_globals_f.global_value%type:= NULL;

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;

Line 266: l_earning_lower ff_globals_f.global_value%type:= 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;

Line 1207: l_earning ff_globals_f.global_value%type:= 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;

Line 1208: l_earning_lower ff_globals_f.global_value%type:= 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;