APPS.PQH_DFS_INS dependencies on PQH_DFLT_FUND_SRCS

Line 56: -- Insert the row into: pqh_dflt_fund_srcs

52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_dflt_fund_srcs
57: --
58: insert into pqh_dflt_fund_srcs
59: ( dflt_fund_src_id,
60: dflt_budget_element_id,

Line 58: insert into pqh_dflt_fund_srcs

54: --
55: --
56: -- Insert the row into: pqh_dflt_fund_srcs
57: --
58: insert into pqh_dflt_fund_srcs
59: ( dflt_fund_src_id,
60: dflt_budget_element_id,
61: dflt_dist_percentage,
62: project_id,

Line 143: Cursor C_Sel1 is select pqh_dflt_fund_srcs_s.nextval from sys.dual;

139: Procedure pre_insert(p_rec in out nocopy pqh_dfs_shd.g_rec_type) is
140: --
141: l_proc varchar2(72) := g_package||'pre_insert';
142: --
143: Cursor C_Sel1 is select pqh_dflt_fund_srcs_s.nextval from sys.dual;
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --

Line 199: from pqh_dflt_fund_srcs

195: l_sum number(15,2) := 0;
196:
197: cursor csr_element(p_dflt_budget_element_id in number) is
198: select SUM(NVL(dflt_dist_percentage,0))
199: from pqh_dflt_fund_srcs
200: where dflt_budget_element_id = p_dflt_budget_element_id;
201:
202:
203: --

Line 246: (p_module_name => 'pqh_dflt_fund_srcs'

242: --
243: when hr_api.cannot_find_prog_unit then
244: --
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'pqh_dflt_fund_srcs'
247: ,p_hook_type => 'AI');
248: --
249: end;
250: --