APPS.BEN_DISTRIBUTE_RATES dependencies on PER_ALL_ASSIGNMENTS_F

Line 1579: per_all_assignments_f asg,

1575: eln.element_type_id
1576: from ben_prtt_rt_val prv,
1577: ben_per_in_ler pil,
1578: pay_element_entry_values_f evl,
1579: per_all_assignments_f asg,
1580: pay_element_entries_f een,
1581: pay_element_links_f eln,
1582: pay_element_types_f ety
1583: where prv.acty_base_rt_id = p_acty_base_rt_id

Line 1782: per_all_assignments_f asg,

1778: --
1779: cursor c_bal_date(v_start_date date, v_end_date in date) is
1780: select max(pac.effective_date) + 1
1781: from pay_person_latest_balances plb,
1782: per_all_assignments_f asg,
1783: pay_assignment_actions paa,
1784: pay_payroll_actions pac
1785: where plb.person_id = l_epe.person_id
1786: and asg.assignment_type <> 'C'

Line 3191: from per_all_assignments_f ass

3187: --
3188: cursor c_first_payroll (p_person_id number,
3189: p_effective_date date) is
3190: select payroll_id
3191: from per_all_assignments_f ass
3192: where ass.person_id = p_person_id
3193: and ass.primary_flag = 'Y'
3194: and ass.assignment_type <> 'C'
3195: and p_effective_date between ass.effective_start_date

Line 3551: from per_all_assignments_f ass

3547: --
3548: cursor c_first_payroll (p_person_id number,
3549: p_effective_date date) is
3550: select payroll_id
3551: from per_all_assignments_f ass
3552: where ass.person_id = p_person_id
3553: and ass.primary_flag = 'Y'
3554: and ass.assignment_type <> 'C'
3555: and p_effective_date between ass.effective_start_date

Line 4429: from hr_locations_all loc, per_all_assignments_f asg

4425:
4426: cursor get_asg_info is
4427: select asg.assignment_id, asg.organization_id, loc.region_2 state, asg.location_id,
4428: asg.payroll_id
4429: from hr_locations_all loc, per_all_assignments_f asg
4430: where asg.person_id = p_person_id
4431: and asg.assignment_type <> 'C'
4432: and asg.primary_flag = 'Y'
4433: and loc.location_id(+) = asg.location_id

Line 4769: per_all_assignments_f

4765: is
4766: /*
4767: cursor c_payroll_id is
4768: select payroll_id from
4769: per_all_assignments_f
4770: where person_id = p_person_id
4771: and assignment_type <> 'C'
4772: and p_effective_date between effective_start_date and effective_end_date
4773: and primary_flag = 'Y';

Line 4774: l_payroll_id per_all_assignments_f.payroll_id%type;

4770: where person_id = p_person_id
4771: and assignment_type <> 'C'
4772: and p_effective_date between effective_start_date and effective_end_date
4773: and primary_flag = 'Y';
4774: l_payroll_id per_all_assignments_f.payroll_id%type;
4775: */
4776: --GEVITY
4777: cursor c_abr(cv_enrt_rt_id number,cv_effective_date date )
4778: is select abr.rate_periodization_rl, ecr.acty_base_rt_id

Line 4807: l_assignment_id per_all_assignments_f.assignment_id%type;

4803: --
4804: l_dfnd_dummy number;
4805: l_ann_dummy number;
4806: l_cmcd_dummy number;
4807: l_assignment_id per_all_assignments_f.assignment_id%type;
4808: l_payroll_id per_all_assignments_f.payroll_id%type;
4809: l_organization_id per_all_assignments_f.organization_id%type;
4810: --GEVITY
4811: not_supported exception;

Line 4808: l_payroll_id per_all_assignments_f.payroll_id%type;

4804: l_dfnd_dummy number;
4805: l_ann_dummy number;
4806: l_cmcd_dummy number;
4807: l_assignment_id per_all_assignments_f.assignment_id%type;
4808: l_payroll_id per_all_assignments_f.payroll_id%type;
4809: l_organization_id per_all_assignments_f.organization_id%type;
4810: --GEVITY
4811: not_supported exception;
4812: l_trace_param varchar2(30);

Line 4809: l_organization_id per_all_assignments_f.organization_id%type;

4805: l_ann_dummy number;
4806: l_cmcd_dummy number;
4807: l_assignment_id per_all_assignments_f.assignment_id%type;
4808: l_payroll_id per_all_assignments_f.payroll_id%type;
4809: l_organization_id per_all_assignments_f.organization_id%type;
4810: --GEVITY
4811: not_supported exception;
4812: l_trace_param varchar2(30);
4813: l_trace_on boolean;