APPS.PAY_PBF_DEL dependencies on PAY_BALANCE_FEEDS_F

Line 71: delete from pay_balance_feeds_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from pay_balance_feeds_f
72: where balance_feed_id = p_rec.balance_feed_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

Line 82: delete from pay_balance_feeds_f

78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --
82: delete from pay_balance_feeds_f
83: where balance_feed_id = p_rec.balance_feed_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_pbf_shd.g_api_dml := false; -- Unset the api dml status

Line 392: (p_module_name => 'PAY_BALANCE_FEEDS_F'

388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'PAY_BALANCE_FEEDS_F'
393: ,p_hook_type => 'AD');
394: --
395: end;
396: --

Line 498: from pay_balance_feeds_f

494: --
495:
496: cursor csr_sel is
497: select balance_type_id, input_value_id
498: from pay_balance_feeds_f
499: where balance_feed_id =p_balance_feed_id;
500:
501: l_rec pay_pbf_shd.g_rec_type;
502: l_proc varchar2(72) := g_package||'del';

Line 503: l_balance_type_id pay_balance_feeds_f.balance_type_id%TYPE;

499: where balance_feed_id =p_balance_feed_id;
500:
501: l_rec pay_pbf_shd.g_rec_type;
502: l_proc varchar2(72) := g_package||'del';
503: l_balance_type_id pay_balance_feeds_f.balance_type_id%TYPE;
504: l_input_value_id pay_balance_feeds_f.input_value_id%TYPE;
505: l_exist_run_result_warning boolean;
506: --
507: Begin

Line 504: l_input_value_id pay_balance_feeds_f.input_value_id%TYPE;

500:
501: l_rec pay_pbf_shd.g_rec_type;
502: l_proc varchar2(72) := g_package||'del';
503: l_balance_type_id pay_balance_feeds_f.balance_type_id%TYPE;
504: l_input_value_id pay_balance_feeds_f.input_value_id%TYPE;
505: l_exist_run_result_warning boolean;
506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);