DBA Data[Home] [Help]

APPS.BEN_PDP_UPD dependencies on BEN_ELIG_CVRD_DPNT_F

Line 77: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',

73: -- version number.
74: --
75: p_rec.object_version_number :=
76: dt_api.get_object_version_number
77: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
78: p_base_key_column => 'elig_cvrd_dpnt_id',
79: p_base_key_value => p_rec.elig_cvrd_dpnt_id);
80: --
81: ben_pdp_shd.g_api_dml := true; -- Set the api dml status

Line 83: -- Update the ben_elig_cvrd_dpnt_f Row

79: p_base_key_value => p_rec.elig_cvrd_dpnt_id);
80: --
81: ben_pdp_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_cvrd_dpnt_f Row
84: --
85: update ben_elig_cvrd_dpnt_f
86: set
87: elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id,

Line 85: update ben_elig_cvrd_dpnt_f

81: ben_pdp_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_cvrd_dpnt_f Row
84: --
85: update ben_elig_cvrd_dpnt_f
86: set
87: elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id,
88: business_group_id = p_rec.business_group_id,
89: prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id,

Line 356: from ben_elig_cvrd_dpnt_f

352: l_eed date;
353: --
354: cursor csr_rowid is
355: select rowid, effective_start_date, effective_end_date
356: from ben_elig_cvrd_dpnt_f
357: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
358: and p_effective_date between
359: effective_start_date and effective_end_date;
360:

Line 363: from ben_elig_cvrd_dpnt_f

359: effective_start_date and effective_end_date;
360:
361: cursor csr_rowid_u is
362: select rowid
363: from ben_elig_cvrd_dpnt_f
364: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
365: and p_effective_date -1 between
366: effective_start_date and effective_end_date;
367: --

Line 590: (p_module_name => 'ben_elig_cvrd_dpnt_f'

586: --
587: when hr_api.cannot_find_prog_unit then
588: --
589: hr_api.cannot_find_prog_unit_error
590: (p_module_name => 'ben_elig_cvrd_dpnt_f'
591: ,p_hook_type => 'AU');
592: --
593: end;
594: --