eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PGM_BUS dependencies on FF_FORMULAS_F

Line 117: from ff_formulas_f ff ,

113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from ff_formulas_f ff ,
118: per_business_groups pbg
119: where ff.formula_id = p_auto_enrt_mthd_rl
120: and ff.formula_type_id = -146
121: and pbg.business_group_id = p_business_group_id

Line 262: from ff_formulas_f ff ,

258: l_dummy varchar2(1);
259: --
260: cursor c1 is
261: select null
262: from ff_formulas_f ff ,
263: per_business_groups pbg
264: where ff.formula_id = p_enrt_rl
265: and ff.formula_type_id = -393
266: and pbg.business_group_id = p_business_group_id

Line 355: from ff_formulas_f ff ,

351: l_dummy varchar2(1);
352: --
353: cursor c1 is
354: select null
355: from ff_formulas_f ff ,
356: per_business_groups pbg
357: where ff.formula_id = p_enrt_cvg_strt_dt_rl
358: and ff.formula_type_id = -29
359: and pbg.business_group_id = p_business_group_id

Line 448: from ff_formulas_f ff ,

444: l_dummy varchar2(1);
445: --
446: cursor c1 is
447: select null
448: from ff_formulas_f ff ,
449: per_business_groups pbg
450: where ff.formula_id = p_enrt_cvg_end_dt_rl
451: and ff.formula_type_id = -30
452: and pbg.business_group_id = p_business_group_id

Line 648: from ff_formulas_f ff ,

644: l_dummy varchar2(1);
645: --
646: cursor c1 is
647: select null
648: from ff_formulas_f ff ,
649: per_business_groups pbg
650: where ff.formula_id = p_dpnt_cvg_strt_dt_rl
651: and ff.formula_type_id = -27
652: and pbg.business_group_id = p_business_group_id

Line 740: from ff_formulas_f ff ,

736: l_dummy varchar2(1);
737: --
738: cursor c1 is
739: select null
740: from ff_formulas_f ff ,
741: per_business_groups pbg
742: where ff.formula_id = p_rt_end_dt_rl
743: and ff.formula_type_id = -67
744: and pbg.business_group_id = p_business_group_id

Line 834: from ff_formulas_f ff ,

830: l_dummy varchar2(1);
831: --
832: cursor c1 is
833: select null
834: from ff_formulas_f ff ,
835: per_business_groups pbg
836: where ff.formula_id = p_rt_strt_dt_rl
837: and ff.formula_type_id = -66
838: and pbg.business_group_id = p_business_group_id

Line 929: from ff_formulas_f ff ,

925: l_dummy varchar2(1);
926: --
927: cursor c1 is
928: select null
929: from ff_formulas_f ff ,
930: per_business_groups pbg
931: where ff.formula_id = p_dpnt_cvg_end_dt_rl
932: and ff.formula_type_id = -28
933: and pbg.business_group_id = p_business_group_id

Line 1022: from ff_formulas_f ff ,

1018: l_dummy varchar2(1);
1019: --
1020: cursor c1 is
1021: select null
1022: from ff_formulas_f ff ,
1023: per_business_groups pbg
1024: where ff.formula_id = p_prtn_end_dt_rl
1025: and ff.formula_type_id = -83
1026: and pbg.business_group_id = p_business_group_id

Line 1115: from ff_formulas_f ff ,

1111: l_dummy varchar2(1);
1112: --
1113: cursor c1 is
1114: select null
1115: from ff_formulas_f ff ,
1116: per_business_groups pbg
1117: where ff.formula_id = p_prtn_strt_dt_rl
1118: and ff.formula_type_id = -82
1119: and pbg.business_group_id = p_business_group_id

Line 3940: from ff_formulas_f ff,

3936: l_dummy varchar2(1);
3937: --
3938: cursor c1(p_rule number,p_rule_type_id number) is
3939: select null
3940: from ff_formulas_f ff,
3941: per_business_groups pbg
3942: where ff.formula_id = p_rule
3943: and ff.formula_type_id = p_rule_type_id
3944: and pbg.business_group_id = p_business_group_id

Line 5857: (p_base_table_name => 'ff_formulas_f',

5853: --
5854:
5855: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5856: NOT (dt_api.check_min_max_dates
5857: (p_base_table_name => 'ff_formulas_f',
5858: p_base_key_column => 'formula_id',
5859: p_base_key_value => p_enrt_cvg_end_dt_rl,
5860: p_from_date => p_validation_start_date,
5861: p_to_date => p_validation_end_date))) Then

Line 5862: l_table_name := 'ff_formulas_f';

5858: p_base_key_column => 'formula_id',
5859: p_base_key_value => p_enrt_cvg_end_dt_rl,
5860: p_from_date => p_validation_start_date,
5861: p_to_date => p_validation_end_date))) Then
5862: l_table_name := 'ff_formulas_f';
5863: Raise l_integrity_error;
5864: End If;
5865: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5866: NOT (dt_api.check_min_max_dates

Line 5867: (p_base_table_name => 'ff_formulas_f',

5863: Raise l_integrity_error;
5864: End If;
5865: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5866: NOT (dt_api.check_min_max_dates
5867: (p_base_table_name => 'ff_formulas_f',
5868: p_base_key_column => 'formula_id',
5869: p_base_key_value => p_enrt_cvg_strt_dt_rl,
5870: p_from_date => p_validation_start_date,
5871: p_to_date => p_validation_end_date))) Then

Line 5872: l_table_name := 'ff_formulas_f';

5868: p_base_key_column => 'formula_id',
5869: p_base_key_value => p_enrt_cvg_strt_dt_rl,
5870: p_from_date => p_validation_start_date,
5871: p_to_date => p_validation_end_date))) Then
5872: l_table_name := 'ff_formulas_f';
5873: Raise l_integrity_error;
5874: End If;
5875: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5876: NOT (dt_api.check_min_max_dates

Line 5877: (p_base_table_name => 'ff_formulas_f',

5873: Raise l_integrity_error;
5874: End If;
5875: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5876: NOT (dt_api.check_min_max_dates
5877: (p_base_table_name => 'ff_formulas_f',
5878: p_base_key_column => 'formula_id',
5879: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
5880: p_from_date => p_validation_start_date,
5881: p_to_date => p_validation_end_date))) Then

Line 5882: l_table_name := 'ff_formulas_f';

5878: p_base_key_column => 'formula_id',
5879: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
5880: p_from_date => p_validation_start_date,
5881: p_to_date => p_validation_end_date))) Then
5882: l_table_name := 'ff_formulas_f';
5883: Raise l_integrity_error;
5884: End If;
5885: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5886: NOT (dt_api.check_min_max_dates

Line 5887: (p_base_table_name => 'ff_formulas_f',

5883: Raise l_integrity_error;
5884: End If;
5885: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5886: NOT (dt_api.check_min_max_dates
5887: (p_base_table_name => 'ff_formulas_f',
5888: p_base_key_column => 'formula_id',
5889: p_base_key_value => p_dpnt_cvg_end_dt_rl,
5890: p_from_date => p_validation_start_date,
5891: p_to_date => p_validation_end_date))) Then

Line 5892: l_table_name := 'ff_formulas_f';

5888: p_base_key_column => 'formula_id',
5889: p_base_key_value => p_dpnt_cvg_end_dt_rl,
5890: p_from_date => p_validation_start_date,
5891: p_to_date => p_validation_end_date))) Then
5892: l_table_name := 'ff_formulas_f';
5893: Raise l_integrity_error;
5894: End If;
5895: /*
5896: If ((nvl(p_prtn_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 5898: (p_base_table_name => 'ff_formulas_f',

5894: End If;
5895: /*
5896: If ((nvl(p_prtn_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5897: NOT (dt_api.check_min_max_dates
5898: (p_base_table_name => 'ff_formulas_f',
5899: p_base_key_column => 'formula_id',
5900: p_base_key_value => p_prtn_end_dt_rl,
5901: p_from_date => p_validation_start_date,
5902: p_to_date => p_validation_end_date))) Then

Line 5903: l_table_name := 'ff_formulas_f';

5899: p_base_key_column => 'formula_id',
5900: p_base_key_value => p_prtn_end_dt_rl,
5901: p_from_date => p_validation_start_date,
5902: p_to_date => p_validation_end_date))) Then
5903: l_table_name := 'ff_formulas_f';
5904: Raise l_integrity_error;
5905: End If;
5906: If ((nvl(p_prtn_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5907: NOT (dt_api.check_min_max_dates

Line 5908: (p_base_table_name => 'ff_formulas_f',

5904: Raise l_integrity_error;
5905: End If;
5906: If ((nvl(p_prtn_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5907: NOT (dt_api.check_min_max_dates
5908: (p_base_table_name => 'ff_formulas_f',
5909: p_base_key_column => 'formula_id',
5910: p_base_key_value => p_prtn_strt_dt_rl,
5911: p_from_date => p_validation_start_date,
5912: p_to_date => p_validation_end_date))) Then

Line 5913: l_table_name := 'ff_formulas_f';

5909: p_base_key_column => 'formula_id',
5910: p_base_key_value => p_prtn_strt_dt_rl,
5911: p_from_date => p_validation_start_date,
5912: p_to_date => p_validation_end_date))) Then
5913: l_table_name := 'ff_formulas_f';
5914: Raise l_integrity_error;
5915: End If;
5916: */
5917: --