APPS.HR_JP_AST_UTILITY_PKG dependencies on HR_ASSIGNMENT_SETS

Line 30: from hr_assignment_sets

26: l_formula_type_id number;
27: l_formula_name ff_formulas_f.formula_name%type;
28: cursor csr_asg_set is
29: select null
30: from hr_assignment_sets
31: where upper(assignment_set_name) = upper(p_assignment_set_name)
32: and business_group_id = p_business_group_id;
33: begin
34: hr_utility.set_location('Entering : ' || l_proc, 10);

Line 80: select hr_assignment_sets_s.nextval

76: chk_assignment_set_name(
77: p_assignment_set_name => p_assignment_set_name,
78: p_business_group_id => p_business_group_id);
79: --
80: select hr_assignment_sets_s.nextval
81: into p_assignment_set_id
82: from dual;
83: --
84: hr_assignment_sets_pkg.insert_row(

Line 84: hr_assignment_sets_pkg.insert_row(

80: select hr_assignment_sets_s.nextval
81: into p_assignment_set_id
82: from dual;
83: --
84: hr_assignment_sets_pkg.insert_row(
85: p_rowid => l_rowid,
86: p_assignment_set_id => p_assignment_set_id,
87: p_business_group_id => p_business_group_id,
88: p_payroll_id => p_payroll_id,

Line 111: l_assignment_set_name hr_assignment_sets.assignment_set_name%type

107: --
108: -- If not submitted from SRS, fnd_global.conc_request_id returns "-1"
109: -- which causes error in hr_chkfmt package.
110: --
111: l_assignment_set_name hr_assignment_sets.assignment_set_name%type
112: := p_prefix || to_char(greatest(fnd_global.conc_request_id, 0));
113: l_counter number := 0;
114: begin
115: hr_utility.set_location('Entering : ' || l_proc, 10);

Line 217: from hr_assignment_sets

213: g_include_or_excludes.delete;
214: --
215: select formula_id
216: into g_formula_id
217: from hr_assignment_sets
218: where assignment_set_id = p_assignment_set_id;
219: --
220: g_amendment_type := 'N';
221: if g_formula_id is null then

Line 498: from hr_assignment_sets

494: l_formula_id number;
495: l_include_flag varchar2(1);
496: cursor csr_formula_id is
497: select formula_id
498: from hr_assignment_sets
499: where assignment_set_id = p_assignment_set_id;
500: cursor csr_include is
501: select 'Y'
502: from hr_assignment_set_amendments