APPS.PAY_MX_PAYREG_PKG dependencies on HR_ASSIGNMENT_SET

Line 250: FROM hr_assignment_set_amendments hasa ,

246: ppa.action_type,
247: ppa.effective_date,
248: act.source_action_id,
249: nvl(ppa.start_date,ppa.effective_date)
250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf

Line 476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;

472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;
479: l_run_eff_date DATE;
480: run_action_type VARCHAR2(30);

Line 601: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);

597: hr_utility.set_location(l_proc_name,55);
598: l_asg_flag := 'N';
599: IF l_asg_set_id IS NOT NULL THEN
600: hr_utility.set_location(l_proc_name,60);
601: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);
602: ELSE -- l_asg_set_id is null
603: hr_utility.set_location(l_proc_name,65);
604: l_asg_flag := 'Y';
605: END IF;

Line 1234: FROM hr_assignment_sets

1230: AND hou.organization_id = leghn.entity_id;
1231:
1232: CURSOR c_get_assig_set_id (cp_assignment_set_id NUMBER) IS
1233: SELECT assignment_set_name
1234: FROM hr_assignment_sets
1235: WHERE assignment_set_id = cp_assignment_set_id;
1236:
1237: CURSOR c_get_dimension_type (cp_dimension_type NUMBER) IS
1238: SELECT flv.meaning