DBA Data[Home] [Help]

APPS.BEN_PBB_UPD dependencies on BEN_PER_BNFTS_BAL_F

Line 77: (p_base_table_name => 'ben_per_bnfts_bal_f',

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

Line 83: -- Update the ben_per_bnfts_bal_f Row

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

Line 85: update ben_per_bnfts_bal_f

81: ben_pbb_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_per_bnfts_bal_f Row
84: --
85: update ben_per_bnfts_bal_f
86: set
87: per_bnfts_bal_id = p_rec.per_bnfts_bal_id,
88: val = p_rec.val,
89: bnfts_bal_id = p_rec.bnfts_bal_id,

Line 347: from ben_per_bnfts_bal_f

343: l_eed date;
344: --
345: cursor csr_rowid is
346: select rowid, effective_start_date, effective_end_date
347: from ben_per_bnfts_bal_f
348: where per_bnfts_bal_id = p_rec.per_bnfts_bal_id
349: and p_effective_date between
350: effective_start_date and effective_end_date;
351:

Line 354: from ben_per_bnfts_bal_f

350: effective_start_date and effective_end_date;
351:
352: cursor csr_rowid_u is
353: select rowid
354: from ben_per_bnfts_bal_f
355: where per_bnfts_bal_id = p_rec.per_bnfts_bal_id
356: and p_effective_date -1 between
357: effective_start_date and effective_end_date;
358: --

Line 542: (p_module_name => 'ben_per_bnfts_bal_f'

538: --
539: when hr_api.cannot_find_prog_unit then
540: --
541: hr_api.cannot_find_prog_unit_error
542: (p_module_name => 'ben_per_bnfts_bal_f'
543: ,p_hook_type => 'AU');
544: --
545: end;
546: --