APPS.HR_JP_AST_UTILITY_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 13: type t_include_or_exclude_tbl is table of hr_assignment_set_amendments.include_or_exclude%type

9: --
10: g_assignment_set_id number;
11: g_formula_id number;
12: g_amendment_type varchar2(1);
13: type t_include_or_exclude_tbl is table of hr_assignment_set_amendments.include_or_exclude%type
14: index by binary_integer;
15: g_include_or_excludes t_include_or_exclude_tbl;
16: -- ----------------------------------------------------------------------------
17: -- |-----------------------< chk_assignment_set_name >------------------------|

Line 189: from hr_assignment_set_amendments

185: select 'Y'
186: from dual
187: where exists(
188: select null
189: from hr_assignment_set_amendments
190: where assignment_set_id = p_assignment_set_id
191: and include_or_exclude = p_include_or_exclude);
192: begin
193: open csr_exists;

Line 271: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;

267: --
268: type t_number_tbl is table of number index by binary_integer;
269: l_assignment_ids t_number_tbl;
270: l_include_or_excludes t_include_or_exclude_tbl;
271: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
272: l_include_flag varchar2(1);
273: begin
274: hr_utility.set_location('Entering: ' || l_proc, 10);
275: --

Line 305: from hr_assignment_set_amendments

301: include_or_exclude
302: bulk collect into
303: l_assignment_ids,
304: l_include_or_excludes
305: from hr_assignment_set_amendments
306: where assignment_set_id = p_assignment_set_id;
307: --
308: for i in 1..l_assignment_ids.count loop
309: g_include_or_excludes(l_assignment_ids(i)) := l_include_or_excludes(i);

Line 456: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;

452: p_populate_fs_flag in varchar2 default 'N') return varchar2
453: is
454: l_proc varchar2(61) := c_package || 'assignment_set_validate';
455: l_include_flag varchar2(1);
456: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
457: begin
458: hr_utility.set_location('Entering: ' || l_proc, 10);
459: --
460: get_assignment_set_info(p_assignment_set_id);

Line 502: from hr_assignment_set_amendments

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
503: where assignment_set_id = p_assignment_set_id
504: and include_or_exclude = 'I'
505: and rownum < 2;
506: --

Line 568: from hr_assignment_set_amendments asa,

564: from (
565: select /*+ ORDERED */
566: asg2.assignment_id,
567: min(asg2.effective_start_date) effective_start_date
568: from hr_assignment_set_amendments asa,
569: per_all_assignments_f asg1,
570: per_periods_of_service ppos,
571: per_all_assignments_f asg2
572: where asa.assignment_set_id = p_assignment_set_id

Line 616: hr_assignment_set_amendments asa

612: min(asa.include_or_exclude) include_or_exclude
613: from per_all_assignments_f asg1,
614: per_periods_of_service ppos,
615: per_all_assignments_f asg2,
616: hr_assignment_set_amendments asa
617: where asg1.payroll_id = p_payroll_id
618: and p_effective_date
619: between asg1.effective_start_date and asg1.effective_end_date
620: and ppos.period_of_service_id = asg1.period_of_service_id