eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PROVIDER_POOLS dependencies on PER_ALL_ASSIGNMENTS_F

Line 323: from per_all_assignments_f asg,

319: cursor c_person_rule_info is
320: select asg.assignment_id,
321: asg.organization_id,
322: loc.region_2
323: from per_all_assignments_f asg,
324: hr_locations_all loc
325: where
326: asg.person_id = p_person_id and
327: asg.assignment_type <> 'C'and

Line 3355: per_all_assignments_f asg,

3351: ben_elig_per_elctbl_chc epe,
3352: ben_enrt_rt ecr,
3353: ben_prtt_rt_val prv,
3354: ben_prtt_enrt_rslt_f rslt,
3355: per_all_assignments_f asg,
3356: hr_locations_all loc,
3357: ben_oipl_f oipl
3358: where
3359: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 3432: per_all_assignments_f asg,

3428: ben_enrt_bnft enb,
3429: ben_enrt_rt ecr,
3430: ben_prtt_rt_val prv,
3431: ben_prtt_enrt_rslt_f rslt,
3432: per_all_assignments_f asg,
3433: hr_locations_all loc,
3434: ben_oipl_f oipl
3435: where
3436: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 4156: l_assignment_id per_all_assignments_f.assignment_id%type;

4152: --
4153: l_dfnd_dummy number;
4154: l_ann_dummy number;
4155: l_cmcd_dummy number;
4156: l_assignment_id per_all_assignments_f.assignment_id%type;
4157: l_payroll_id per_all_assignments_f.payroll_id%type;
4158: l_organization_id per_all_assignments_f.organization_id%type;
4159: --END GEVITY
4160: begin

Line 4157: l_payroll_id per_all_assignments_f.payroll_id%type;

4153: l_dfnd_dummy number;
4154: l_ann_dummy number;
4155: l_cmcd_dummy number;
4156: l_assignment_id per_all_assignments_f.assignment_id%type;
4157: l_payroll_id per_all_assignments_f.payroll_id%type;
4158: l_organization_id per_all_assignments_f.organization_id%type;
4159: --END GEVITY
4160: begin
4161: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4158: l_organization_id per_all_assignments_f.organization_id%type;

4154: l_ann_dummy number;
4155: l_cmcd_dummy number;
4156: l_assignment_id per_all_assignments_f.assignment_id%type;
4157: l_payroll_id per_all_assignments_f.payroll_id%type;
4158: l_organization_id per_all_assignments_f.organization_id%type;
4159: --END GEVITY
4160: begin
4161: hr_utility.set_location('Entering:'|| l_proc, 10);
4162: hr_utility.set_location('crdt_pool_rslt_id='||to_char(g_credit_pool_result_id),10);

Line 5493: per_all_assignments_f asg,

5489: from
5490: ben_bnft_pool_rlovr_rqmt_f prr,
5491: ben_prtt_rt_val prv,
5492: ben_prtt_enrt_rslt_f rslt,
5493: per_all_assignments_f asg,
5494: hr_locations_all loc,
5495: ben_oipl_f oipl
5496: where
5497: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and