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 341: from per_all_assignments_f asg,

337: cursor c_person_rule_info is
338: select asg.assignment_id,
339: asg.organization_id,
340: loc.region_2
341: from per_all_assignments_f asg,
342: hr_locations_all loc
343: where
344: asg.person_id = p_person_id and
345: asg.assignment_type <> 'C'and

Line 3534: per_all_assignments_f asg,

3530: ben_elig_per_elctbl_chc epe,
3531: ben_enrt_rt ecr,
3532: ben_prtt_rt_val prv,
3533: ben_prtt_enrt_rslt_f rslt,
3534: per_all_assignments_f asg,
3535: hr_locations_all loc,
3536: ben_oipl_f oipl
3537: where
3538: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 3611: per_all_assignments_f asg,

3607: ben_enrt_bnft enb,
3608: ben_enrt_rt ecr,
3609: ben_prtt_rt_val prv,
3610: ben_prtt_enrt_rslt_f rslt,
3611: per_all_assignments_f asg,
3612: hr_locations_all loc,
3613: ben_oipl_f oipl
3614: where
3615: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 4335: l_assignment_id per_all_assignments_f.assignment_id%type;

4331: --
4332: l_dfnd_dummy number;
4333: l_ann_dummy number;
4334: l_cmcd_dummy number;
4335: l_assignment_id per_all_assignments_f.assignment_id%type;
4336: l_payroll_id per_all_assignments_f.payroll_id%type;
4337: l_organization_id per_all_assignments_f.organization_id%type;
4338: --END GEVITY
4339: begin

Line 4336: l_payroll_id per_all_assignments_f.payroll_id%type;

4332: l_dfnd_dummy number;
4333: l_ann_dummy number;
4334: l_cmcd_dummy number;
4335: l_assignment_id per_all_assignments_f.assignment_id%type;
4336: l_payroll_id per_all_assignments_f.payroll_id%type;
4337: l_organization_id per_all_assignments_f.organization_id%type;
4338: --END GEVITY
4339: begin
4340: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4337: l_organization_id per_all_assignments_f.organization_id%type;

4333: l_ann_dummy number;
4334: l_cmcd_dummy number;
4335: l_assignment_id per_all_assignments_f.assignment_id%type;
4336: l_payroll_id per_all_assignments_f.payroll_id%type;
4337: l_organization_id per_all_assignments_f.organization_id%type;
4338: --END GEVITY
4339: begin
4340: hr_utility.set_location('Entering:'|| l_proc, 10);
4341: hr_utility.set_location('crdt_pool_rslt_id='||to_char(g_credit_pool_result_id),10);

Line 5670: per_all_assignments_f asg,

5666: from
5667: ben_bnft_pool_rlovr_rqmt_f prr,
5668: ben_prtt_rt_val prv,
5669: ben_prtt_enrt_rslt_f rslt,
5670: per_all_assignments_f asg,
5671: hr_locations_all loc,
5672: ben_oipl_f oipl
5673: where
5674: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and