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

Line 3617: from ff_formulas_f ff,

3613: l_dummy varchar2(1);
3614: --
3615: cursor c1(p_rule number,p_rule_type_id number) is
3616: select null
3617: from ff_formulas_f ff,
3618: per_business_groups pbg
3619: where ff.formula_id = p_rule
3620: and ff.formula_type_id = p_rule_type_id
3621: and pbg.business_group_id = p_business_group_id

Line 4814: (p_base_table_name => 'ff_formulas_f',

4810: p_argument_value => p_validation_end_date);
4811: --
4812: If ((nvl(p_auto_enrt_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4813: NOT (dt_api.check_min_max_dates
4814: (p_base_table_name => 'ff_formulas_f',
4815: p_base_key_column => 'formula_id',
4816: p_base_key_value => p_auto_enrt_mthd_rl,
4817: p_from_date => p_validation_start_date,
4818: p_to_date => p_validation_end_date))) Then

Line 4819: l_table_name := 'ff_formulas_f';

4815: p_base_key_column => 'formula_id',
4816: p_base_key_value => p_auto_enrt_mthd_rl,
4817: p_from_date => p_validation_start_date,
4818: p_to_date => p_validation_end_date))) Then
4819: l_table_name := 'ff_formulas_f';
4820: Raise l_integrity_error;
4821: End If;
4822: If ((nvl(p_mn_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4823: NOT (dt_api.check_min_max_dates

Line 4824: (p_base_table_name => 'ff_formulas_f',

4820: Raise l_integrity_error;
4821: End If;
4822: If ((nvl(p_mn_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4823: NOT (dt_api.check_min_max_dates
4824: (p_base_table_name => 'ff_formulas_f',
4825: p_base_key_column => 'formula_id',
4826: p_base_key_value => p_mn_cvg_rl,
4827: p_from_date => p_validation_start_date,
4828: p_to_date => p_validation_end_date))) Then

Line 4829: l_table_name := 'ff_formulas_f';

4825: p_base_key_column => 'formula_id',
4826: p_base_key_value => p_mn_cvg_rl,
4827: p_from_date => p_validation_start_date,
4828: p_to_date => p_validation_end_date))) Then
4829: l_table_name := 'ff_formulas_f';
4830: Raise l_integrity_error;
4831: End If;
4832: If ((nvl(p_mx_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4833: NOT (dt_api.check_min_max_dates

Line 4834: (p_base_table_name => 'ff_formulas_f',

4830: Raise l_integrity_error;
4831: End If;
4832: If ((nvl(p_mx_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4833: NOT (dt_api.check_min_max_dates
4834: (p_base_table_name => 'ff_formulas_f',
4835: p_base_key_column => 'formula_id',
4836: p_base_key_value => p_mx_cvg_rl,
4837: p_from_date => p_validation_start_date,
4838: p_to_date => p_validation_end_date))) Then

Line 4839: l_table_name := 'ff_formulas_f';

4835: p_base_key_column => 'formula_id',
4836: p_base_key_value => p_mx_cvg_rl,
4837: p_from_date => p_validation_start_date,
4838: p_to_date => p_validation_end_date))) Then
4839: l_table_name := 'ff_formulas_f';
4840: Raise l_integrity_error;
4841: End If;
4842: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
4843: NOT (dt_api.check_min_max_dates

Line 4849: l_table_name := 'ff_formulas_f';

4845: p_base_key_column => 'bnft_prvdr_pool_id',
4846: p_base_key_value => p_bnft_prvdr_pool_id,
4847: p_from_date => p_validation_start_date,
4848: p_to_date => p_validation_end_date))) Then
4849: l_table_name := 'ff_formulas_f';
4850: Raise l_integrity_error;
4851: End If;
4852: If ((nvl(p_enrt_rl, hr_api.g_number) <> hr_api.g_number) and
4853: NOT (dt_api.check_min_max_dates

Line 4854: (p_base_table_name => 'ff_formulas_f',

4850: Raise l_integrity_error;
4851: End If;
4852: If ((nvl(p_enrt_rl, hr_api.g_number) <> hr_api.g_number) and
4853: NOT (dt_api.check_min_max_dates
4854: (p_base_table_name => 'ff_formulas_f',
4855: p_base_key_column => 'formula_id',
4856: p_base_key_value => p_enrt_rl,
4857: p_from_date => p_validation_start_date,
4858: p_to_date => p_validation_end_date))) Then

Line 4859: l_table_name := 'ff_formulas_f';

4855: p_base_key_column => 'formula_id',
4856: p_base_key_value => p_enrt_rl,
4857: p_from_date => p_validation_start_date,
4858: p_to_date => p_validation_end_date))) Then
4859: l_table_name := 'ff_formulas_f';
4860: Raise l_integrity_error;
4861: End If;
4862: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
4863: NOT (dt_api.check_min_max_dates

Line 4864: (p_base_table_name => 'ff_formulas_f',

4860: Raise l_integrity_error;
4861: End If;
4862: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
4863: NOT (dt_api.check_min_max_dates
4864: (p_base_table_name => 'ff_formulas_f',
4865: p_base_key_column => 'formula_id',
4866: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,
4867: p_from_date => p_validation_start_date,
4868: p_to_date => p_validation_end_date))) Then

Line 4869: l_table_name := 'ff_formulas_f';

4865: p_base_key_column => 'formula_id',
4866: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,
4867: p_from_date => p_validation_start_date,
4868: p_to_date => p_validation_end_date))) Then
4869: l_table_name := 'ff_formulas_f';
4870: Raise l_integrity_error;
4871: End If;
4872: If ((nvl(p_mx_wtg_perd_rl, hr_api.g_number) <> hr_api.g_number) and
4873: NOT (dt_api.check_min_max_dates

Line 4874: (p_base_table_name => 'ff_formulas_f',

4870: Raise l_integrity_error;
4871: End If;
4872: If ((nvl(p_mx_wtg_perd_rl, hr_api.g_number) <> hr_api.g_number) and
4873: NOT (dt_api.check_min_max_dates
4874: (p_base_table_name => 'ff_formulas_f',
4875: p_base_key_column => 'formula_id',
4876: p_base_key_value => p_mx_wtg_perd_rl,
4877: p_from_date => p_validation_start_date,
4878: p_to_date => p_validation_end_date))) Then

Line 4879: l_table_name := 'ff_formulas_f';

4875: p_base_key_column => 'formula_id',
4876: p_base_key_value => p_mx_wtg_perd_rl,
4877: p_from_date => p_validation_start_date,
4878: p_to_date => p_validation_end_date))) Then
4879: l_table_name := 'ff_formulas_f';
4880: Raise l_integrity_error;
4881: End If;
4882: If ((nvl(p_nip_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4883: NOT (dt_api.check_min_max_dates

Line 4884: (p_base_table_name => 'ff_formulas_f',

4880: Raise l_integrity_error;
4881: End If;
4882: If ((nvl(p_nip_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4883: NOT (dt_api.check_min_max_dates
4884: (p_base_table_name => 'ff_formulas_f',
4885: p_base_key_column => 'formula_id',
4886: p_base_key_value => p_nip_dflt_enrt_det_rl,
4887: p_from_date => p_validation_start_date,
4888: p_to_date => p_validation_end_date))) Then

Line 4889: l_table_name := 'ff_formulas_f';

4885: p_base_key_column => 'formula_id',
4886: p_base_key_value => p_nip_dflt_enrt_det_rl,
4887: p_from_date => p_validation_start_date,
4888: p_to_date => p_validation_end_date))) Then
4889: l_table_name := 'ff_formulas_f';
4890: Raise l_integrity_error;
4891: End If;
4892: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4893: NOT (dt_api.check_min_max_dates

Line 4894: (p_base_table_name => 'ff_formulas_f',

4890: Raise l_integrity_error;
4891: End If;
4892: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4893: NOT (dt_api.check_min_max_dates
4894: (p_base_table_name => 'ff_formulas_f',
4895: p_base_key_column => 'formula_id',
4896: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4897: p_from_date => p_validation_start_date,
4898: p_to_date => p_validation_end_date))) Then

Line 4899: l_table_name := 'ff_formulas_f';

4895: p_base_key_column => 'formula_id',
4896: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4897: p_from_date => p_validation_start_date,
4898: p_to_date => p_validation_end_date))) Then
4899: l_table_name := 'ff_formulas_f';
4900: Raise l_integrity_error;
4901: End If;
4902: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4903: NOT (dt_api.check_min_max_dates

Line 4904: (p_base_table_name => 'ff_formulas_f',

4900: Raise l_integrity_error;
4901: End If;
4902: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4903: NOT (dt_api.check_min_max_dates
4904: (p_base_table_name => 'ff_formulas_f',
4905: p_base_key_column => 'formula_id',
4906: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4907: p_from_date => p_validation_start_date,
4908: p_to_date => p_validation_end_date))) Then

Line 4909: l_table_name := 'ff_formulas_f';

4905: p_base_key_column => 'formula_id',
4906: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4907: p_from_date => p_validation_start_date,
4908: p_to_date => p_validation_end_date))) Then
4909: l_table_name := 'ff_formulas_f';
4910: Raise l_integrity_error;
4911: End If;
4912: If ((nvl(p_prort_prtl_yr_cvg_rstrn_rl, hr_api.g_number) <> hr_api.g_number) and
4913: NOT (dt_api.check_min_max_dates

Line 4914: (p_base_table_name => 'ff_formulas_f',

4910: Raise l_integrity_error;
4911: End If;
4912: If ((nvl(p_prort_prtl_yr_cvg_rstrn_rl, hr_api.g_number) <> hr_api.g_number) and
4913: NOT (dt_api.check_min_max_dates
4914: (p_base_table_name => 'ff_formulas_f',
4915: p_base_key_column => 'formula_id',
4916: p_base_key_value => p_prort_prtl_yr_cvg_rstrn_rl,
4917: p_from_date => p_validation_start_date,
4918: p_to_date => p_validation_end_date))) Then

Line 4919: l_table_name := 'ff_formulas_f';

4915: p_base_key_column => 'formula_id',
4916: p_base_key_value => p_prort_prtl_yr_cvg_rstrn_rl,
4917: p_from_date => p_validation_start_date,
4918: p_to_date => p_validation_end_date))) Then
4919: l_table_name := 'ff_formulas_f';
4920: Raise l_integrity_error;
4921: End If;
4922: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4923: NOT (dt_api.check_min_max_dates

Line 4949: (p_base_table_name => 'ff_formulas_f',

4945: -- End If;
4946: --
4947: If ((nvl(p_dflt_to_asn_pndg_ctfn_rl, hr_api.g_number) <> hr_api.g_number) and
4948: NOT (dt_api.check_min_max_dates
4949: (p_base_table_name => 'ff_formulas_f',
4950: p_base_key_column => 'formula_id',
4951: p_base_key_value => p_dflt_to_asn_pndg_ctfn_rl,
4952: p_from_date => p_validation_start_date,
4953: p_to_date => p_validation_end_date))) Then

Line 4954: l_table_name := 'ff_formulas_f';

4950: p_base_key_column => 'formula_id',
4951: p_base_key_value => p_dflt_to_asn_pndg_ctfn_rl,
4952: p_from_date => p_validation_start_date,
4953: p_to_date => p_validation_end_date))) Then
4954: l_table_name := 'ff_formulas_f';
4955: Raise l_integrity_error;
4956: End If;
4957: --
4958: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 4960: (p_base_table_name => 'ff_formulas_f',

4956: End If;
4957: --
4958: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4959: NOT (dt_api.check_min_max_dates
4960: (p_base_table_name => 'ff_formulas_f',
4961: p_base_key_column => 'formula_id',
4962: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4963: p_from_date => p_validation_start_date,
4964: p_to_date => p_validation_end_date))) Then

Line 4965: l_table_name := 'ff_formulas_f';

4961: p_base_key_column => 'formula_id',
4962: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4963: p_from_date => p_validation_start_date,
4964: p_to_date => p_validation_end_date))) Then
4965: l_table_name := 'ff_formulas_f';
4966: Raise l_integrity_error;
4967: End If;
4968: --
4969: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 4971: (p_base_table_name => 'ff_formulas_f',

4967: End If;
4968: --
4969: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4970: NOT (dt_api.check_min_max_dates
4971: (p_base_table_name => 'ff_formulas_f',
4972: p_base_key_column => 'formula_id',
4973: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4974: p_from_date => p_validation_start_date,
4975: p_to_date => p_validation_end_date))) Then

Line 4976: l_table_name := 'ff_formulas_f';

4972: p_base_key_column => 'formula_id',
4973: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4974: p_from_date => p_validation_start_date,
4975: p_to_date => p_validation_end_date))) Then
4976: l_table_name := 'ff_formulas_f';
4977: Raise l_integrity_error;
4978: End If;
4979: --
4980: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 4982: (p_base_table_name => 'ff_formulas_f',

4978: End If;
4979: --
4980: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4981: NOT (dt_api.check_min_max_dates
4982: (p_base_table_name => 'ff_formulas_f',
4983: p_base_key_column => 'formula_id',
4984: p_base_key_value => p_enrt_cvg_end_dt_rl,
4985: p_from_date => p_validation_start_date,
4986: p_to_date => p_validation_end_date))) Then

Line 4987: l_table_name := 'ff_formulas_f';

4983: p_base_key_column => 'formula_id',
4984: p_base_key_value => p_enrt_cvg_end_dt_rl,
4985: p_from_date => p_validation_start_date,
4986: p_to_date => p_validation_end_date))) Then
4987: l_table_name := 'ff_formulas_f';
4988: Raise l_integrity_error;
4989: End If;
4990: --
4991: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 4993: (p_base_table_name => 'ff_formulas_f',

4989: End If;
4990: --
4991: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4992: NOT (dt_api.check_min_max_dates
4993: (p_base_table_name => 'ff_formulas_f',
4994: p_base_key_column => 'formula_id',
4995: p_base_key_value => p_enrt_cvg_strt_dt_rl,
4996: p_from_date => p_validation_start_date,
4997: p_to_date => p_validation_end_date))) Then

Line 4998: l_table_name := 'ff_formulas_f';

4994: p_base_key_column => 'formula_id',
4995: p_base_key_value => p_enrt_cvg_strt_dt_rl,
4996: p_from_date => p_validation_start_date,
4997: p_to_date => p_validation_end_date))) Then
4998: l_table_name := 'ff_formulas_f';
4999: Raise l_integrity_error;
5000: End If;
5001: --
5002: If ((nvl(p_postelcn_edit_rl, hr_api.g_number) <> hr_api.g_number) and

Line 5004: (p_base_table_name => 'ff_formulas_f',

5000: End If;
5001: --
5002: If ((nvl(p_postelcn_edit_rl, hr_api.g_number) <> hr_api.g_number) and
5003: NOT (dt_api.check_min_max_dates
5004: (p_base_table_name => 'ff_formulas_f',
5005: p_base_key_column => 'formula_id',
5006: p_base_key_value => p_postelcn_edit_rl,
5007: p_from_date => p_validation_start_date,
5008: p_to_date => p_validation_end_date))) Then

Line 5009: l_table_name := 'ff_formulas_f';

5005: p_base_key_column => 'formula_id',
5006: p_base_key_value => p_postelcn_edit_rl,
5007: p_from_date => p_validation_start_date,
5008: p_to_date => p_validation_end_date))) Then
5009: l_table_name := 'ff_formulas_f';
5010: Raise l_integrity_error;
5011: End If;
5012: --
5013: If ((nvl(p_rt_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 5015: (p_base_table_name => 'ff_formulas_f',

5011: End If;
5012: --
5013: If ((nvl(p_rt_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5014: NOT (dt_api.check_min_max_dates
5015: (p_base_table_name => 'ff_formulas_f',
5016: p_base_key_column => 'formula_id',
5017: p_base_key_value => p_rt_end_dt_rl,
5018: p_from_date => p_validation_start_date,
5019: p_to_date => p_validation_end_date))) Then

Line 5020: l_table_name := 'ff_formulas_f';

5016: p_base_key_column => 'formula_id',
5017: p_base_key_value => p_rt_end_dt_rl,
5018: p_from_date => p_validation_start_date,
5019: p_to_date => p_validation_end_date))) Then
5020: l_table_name := 'ff_formulas_f';
5021: Raise l_integrity_error;
5022: End If;
5023: --
5024: If ((nvl(p_rt_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

Line 5026: (p_base_table_name => 'ff_formulas_f',

5022: End If;
5023: --
5024: If ((nvl(p_rt_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5025: NOT (dt_api.check_min_max_dates
5026: (p_base_table_name => 'ff_formulas_f',
5027: p_base_key_column => 'formula_id',
5028: p_base_key_value => p_rt_strt_dt_rl,
5029: p_from_date => p_validation_start_date,
5030: p_to_date => p_validation_end_date))) Then

Line 5031: l_table_name := 'ff_formulas_f';

5027: p_base_key_column => 'formula_id',
5028: p_base_key_value => p_rt_strt_dt_rl,
5029: p_from_date => p_validation_start_date,
5030: p_to_date => p_validation_end_date))) Then
5031: l_table_name := 'ff_formulas_f';
5032: Raise l_integrity_error;
5033: End If;
5034: --
5035: End If;