APPS.BEN_DISTRIBUTE_RATES dependencies on PER_ALL_ASSIGNMENTS_F

Line 1699: per_all_assignments_f asg,

1695: eln.element_type_id
1696: from ben_prtt_rt_val prv,
1697: ben_per_in_ler pil,
1698: pay_element_entry_values_f evl,
1699: per_all_assignments_f asg,
1700: pay_element_entries_f een,
1701: pay_element_links_f eln,
1702: pay_element_types_f ety
1703: where prv.acty_base_rt_id = p_acty_base_rt_id

Line 1902: per_all_assignments_f asg,

1898: --
1899: cursor c_bal_date(v_start_date date, v_end_date in date) is
1900: select max(pac.effective_date) + 1
1901: from pay_person_latest_balances plb,
1902: per_all_assignments_f asg,
1903: pay_assignment_actions paa,
1904: pay_payroll_actions pac
1905: where plb.person_id = l_epe.person_id
1906: and asg.assignment_type <> 'C'

Line 3408: from per_all_assignments_f ass

3404: --
3405: cursor c_first_payroll (p_person_id number,
3406: p_effective_date date) is
3407: select payroll_id
3408: from per_all_assignments_f ass
3409: where ass.person_id = p_person_id
3410: and ass.primary_flag = 'Y'
3411: and ass.assignment_type <> 'C'
3412: and p_effective_date between ass.effective_start_date

Line 3818: from per_all_assignments_f ass

3814: --
3815: cursor c_first_payroll (p_person_id number,
3816: p_effective_date date) is
3817: select payroll_id
3818: from per_all_assignments_f ass
3819: where ass.person_id = p_person_id
3820: and ass.primary_flag = 'Y'
3821: and ass.assignment_type <> 'C'
3822: and p_effective_date between ass.effective_start_date

Line 4749: from hr_locations_all loc, per_all_assignments_f asg

4745:
4746: cursor get_asg_info is
4747: select asg.assignment_id, asg.organization_id, loc.region_2 state, asg.location_id,
4748: asg.payroll_id
4749: from hr_locations_all loc, per_all_assignments_f asg
4750: where asg.person_id = p_person_id
4751: and asg.assignment_type <> 'C'
4752: and asg.primary_flag = 'Y'
4753: and loc.location_id(+) = asg.location_id

Line 5104: per_all_assignments_f

5100: is
5101: /*
5102: cursor c_payroll_id is
5103: select payroll_id from
5104: per_all_assignments_f
5105: where person_id = p_person_id
5106: and assignment_type <> 'C'
5107: and p_effective_date between effective_start_date and effective_end_date
5108: and primary_flag = 'Y';

Line 5109: l_payroll_id per_all_assignments_f.payroll_id%type;

5105: where person_id = p_person_id
5106: and assignment_type <> 'C'
5107: and p_effective_date between effective_start_date and effective_end_date
5108: and primary_flag = 'Y';
5109: l_payroll_id per_all_assignments_f.payroll_id%type;
5110: */
5111: --GEVITY
5112: cursor c_abr(cv_enrt_rt_id number,cv_effective_date date )
5113: is select abr.rate_periodization_rl, ecr.acty_base_rt_id

Line 5142: l_assignment_id per_all_assignments_f.assignment_id%type;

5138: --
5139: l_dfnd_dummy number;
5140: l_ann_dummy number;
5141: l_cmcd_dummy number;
5142: l_assignment_id per_all_assignments_f.assignment_id%type;
5143: l_payroll_id per_all_assignments_f.payroll_id%type;
5144: l_organization_id per_all_assignments_f.organization_id%type;
5145: --GEVITY
5146: not_supported exception;

Line 5143: l_payroll_id per_all_assignments_f.payroll_id%type;

5139: l_dfnd_dummy number;
5140: l_ann_dummy number;
5141: l_cmcd_dummy number;
5142: l_assignment_id per_all_assignments_f.assignment_id%type;
5143: l_payroll_id per_all_assignments_f.payroll_id%type;
5144: l_organization_id per_all_assignments_f.organization_id%type;
5145: --GEVITY
5146: not_supported exception;
5147: l_trace_param varchar2(30);

Line 5144: l_organization_id per_all_assignments_f.organization_id%type;

5140: l_ann_dummy number;
5141: l_cmcd_dummy number;
5142: l_assignment_id per_all_assignments_f.assignment_id%type;
5143: l_payroll_id per_all_assignments_f.payroll_id%type;
5144: l_organization_id per_all_assignments_f.organization_id%type;
5145: --GEVITY
5146: not_supported exception;
5147: l_trace_param varchar2(30);
5148: l_trace_on boolean;