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_PRG_BUS dependencies on FF_FORMULAS_F

Line 264: from ff_formulas_f ff

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

Line 356: from ff_formulas_f ff

352: l_dummy varchar2(1);
353: --
354: cursor c1 is
355: select null
356: from ff_formulas_f ff
357: ,per_business_groups pbg
358: where ff.formula_id = p_key_ee_det_rl
359: and ff.formula_type_id = -39
360: 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_cntr_nndscrn_rl
451: and ff.formula_type_id = -42
452: and pbg.business_group_id = p_business_group_id

Line 540: from ff_formulas_f ff

536: l_dummy varchar2(1);
537: --
538: cursor c1 is
539: select null
540: from ff_formulas_f ff
541: ,per_business_groups pbg
542: where ff.formula_id = p_cvg_nndscrn_rl
543: and ff.formula_type_id = -41
544: and pbg.business_group_id = p_business_group_id

Line 632: from ff_formulas_f ff

628: l_dummy varchar2(1);
629: --
630: cursor c1 is
631: select null
632: from ff_formulas_f ff
633: ,per_business_groups pbg
634: where ff.formula_id = p_five_pct_ownr_rl
635: and ff.formula_type_id = -154
636: and pbg.business_group_id = p_business_group_id

Line 829: (p_base_table_name => 'ff_formulas_f',

825: p_argument_value => p_validation_end_date);
826: --
827: If ((nvl(p_hghly_compd_det_rl, hr_api.g_number) <> hr_api.g_number) and
828: NOT (dt_api.check_min_max_dates
829: (p_base_table_name => 'ff_formulas_f',
830: p_base_key_column => 'formula_id',
831: p_base_key_value => p_hghly_compd_det_rl,
832: p_from_date => p_validation_start_date,
833: p_to_date => p_validation_end_date))) Then

Line 834: l_table_name := 'ff_formulas_f';

830: p_base_key_column => 'formula_id',
831: p_base_key_value => p_hghly_compd_det_rl,
832: p_from_date => p_validation_start_date,
833: p_to_date => p_validation_end_date))) Then
834: l_table_name := 'ff_formulas_f';
835: Raise l_integrity_error;
836: End If;
837: If ((nvl(p_key_ee_det_rl, hr_api.g_number) <> hr_api.g_number) and
838: NOT (dt_api.check_min_max_dates

Line 839: (p_base_table_name => 'ff_formulas_f',

835: Raise l_integrity_error;
836: End If;
837: If ((nvl(p_key_ee_det_rl, hr_api.g_number) <> hr_api.g_number) and
838: NOT (dt_api.check_min_max_dates
839: (p_base_table_name => 'ff_formulas_f',
840: p_base_key_column => 'formula_id',
841: p_base_key_value => p_key_ee_det_rl,
842: p_from_date => p_validation_start_date,
843: p_to_date => p_validation_end_date))) Then

Line 844: l_table_name := 'ff_formulas_f';

840: p_base_key_column => 'formula_id',
841: p_base_key_value => p_key_ee_det_rl,
842: p_from_date => p_validation_start_date,
843: p_to_date => p_validation_end_date))) Then
844: l_table_name := 'ff_formulas_f';
845: Raise l_integrity_error;
846: End If;
847: If ((nvl(p_cntr_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
848: NOT (dt_api.check_min_max_dates

Line 849: (p_base_table_name => 'ff_formulas_f',

845: Raise l_integrity_error;
846: End If;
847: If ((nvl(p_cntr_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
848: NOT (dt_api.check_min_max_dates
849: (p_base_table_name => 'ff_formulas_f',
850: p_base_key_column => 'formula_id',
851: p_base_key_value => p_cntr_nndscrn_rl,
852: p_from_date => p_validation_start_date,
853: p_to_date => p_validation_end_date))) Then

Line 854: l_table_name := 'ff_formulas_f';

850: p_base_key_column => 'formula_id',
851: p_base_key_value => p_cntr_nndscrn_rl,
852: p_from_date => p_validation_start_date,
853: p_to_date => p_validation_end_date))) Then
854: l_table_name := 'ff_formulas_f';
855: Raise l_integrity_error;
856: End If;
857: If ((nvl(p_cvg_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
858: NOT (dt_api.check_min_max_dates

Line 859: (p_base_table_name => 'ff_formulas_f',

855: Raise l_integrity_error;
856: End If;
857: If ((nvl(p_cvg_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
858: NOT (dt_api.check_min_max_dates
859: (p_base_table_name => 'ff_formulas_f',
860: p_base_key_column => 'formula_id',
861: p_base_key_value => p_cvg_nndscrn_rl,
862: p_from_date => p_validation_start_date,
863: p_to_date => p_validation_end_date))) Then

Line 864: l_table_name := 'ff_formulas_f';

860: p_base_key_column => 'formula_id',
861: p_base_key_value => p_cvg_nndscrn_rl,
862: p_from_date => p_validation_start_date,
863: p_to_date => p_validation_end_date))) Then
864: l_table_name := 'ff_formulas_f';
865: Raise l_integrity_error;
866: End If;
867: If ((nvl(p_five_pct_ownr_rl, hr_api.g_number) <> hr_api.g_number) and
868: NOT (dt_api.check_min_max_dates

Line 869: (p_base_table_name => 'ff_formulas_f',

865: Raise l_integrity_error;
866: End If;
867: If ((nvl(p_five_pct_ownr_rl, hr_api.g_number) <> hr_api.g_number) and
868: NOT (dt_api.check_min_max_dates
869: (p_base_table_name => 'ff_formulas_f',
870: p_base_key_column => 'formula_id',
871: p_base_key_value => p_five_pct_ownr_rl,
872: p_from_date => p_validation_start_date,
873: p_to_date => p_validation_end_date))) Then

Line 874: l_table_name := 'ff_formulas_f';

870: p_base_key_column => 'formula_id',
871: p_base_key_value => p_five_pct_ownr_rl,
872: p_from_date => p_validation_start_date,
873: p_to_date => p_validation_end_date))) Then
874: l_table_name := 'ff_formulas_f';
875: Raise l_integrity_error;
876: End If;
877: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates