APPS.PAY_SIMULATOR_SS_PKG dependencies on PER_BUSINESS_GROUPS

Line 252: from per_business_groups

248: BETWEEN p_start_date
249: AND p_end_date;
250: cursor leg_code is
251: select legislation_code
252: from per_business_groups
253: where business_group_id = p_business_group_id;
254:
255: l_leg_code per_business_groups.legislation_code%type;
256: l_start_date date;

Line 255: l_leg_code per_business_groups.legislation_code%type;

251: select legislation_code
252: from per_business_groups
253: where business_group_id = p_business_group_id;
254:
255: l_leg_code per_business_groups.legislation_code%type;
256: l_start_date date;
257: l_date_earned date;
258: l_date_paid date;
259: l_check number;

Line 589: from per_business_groups_perf pbg,

585:
586: cursor check_actions
587: is
588: select 1
589: from per_business_groups_perf pbg,
590: per_all_assignments_f asg,
591: per_all_assignments_f as2,
592: per_periods_of_service pos
593: where asg.assignment_id = p_assignment_id

Line 701: l_legislation_code per_business_groups.legislation_code%TYPE := null;

697: --
698: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
699: l_element_name pay_element_types_f.element_name%TYPE := null;
700: l_count number := 0;
701: l_legislation_code per_business_groups.legislation_code%TYPE := null;
702: l_business_group_id per_business_groups.business_group_id%TYPE;
703: l_batch_id pay_batch_lines.batch_id%TYPE;
704: l_effective_date pay_batch_lines.effective_date%TYPE;
705: l_date_prof_value varchar2(80);

Line 702: l_business_group_id per_business_groups.business_group_id%TYPE;

698: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
699: l_element_name pay_element_types_f.element_name%TYPE := null;
700: l_count number := 0;
701: l_legislation_code per_business_groups.legislation_code%TYPE := null;
702: l_business_group_id per_business_groups.business_group_id%TYPE;
703: l_batch_id pay_batch_lines.batch_id%TYPE;
704: l_effective_date pay_batch_lines.effective_date%TYPE;
705: l_date_prof_value varchar2(80);
706: l_number_prof_value varchar2(80);