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_DETERMINE_COMMUNICATIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 3570: FROM per_all_assignments_f asg, per_assignment_status_types ast

3566: or
3567: /* check if the person belongs to the org or location specified */
3568: /* Bug 5435002 */
3569: exists (select 's'
3570: FROM per_all_assignments_f asg, per_assignment_status_types ast
3571: WHERE asg.person_id = pil.person_id
3572: AND asg.primary_flag = 'Y'
3573: and (g_parm.organization_id is null or
3574: asg.organization_id = g_parm.organization_id)

Line 3586: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3582: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3583: OR ( ast.per_system_status = 'TERM_ASSIGN'
3584: AND NOT EXISTS (
3585: SELECT assignment_id
3586: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3587: WHERE asg1.assignment_type = 'B'
3588: AND asg1.primary_flag = 'Y'
3589: AND asg1.person_id = pil.person_id
3590: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3601: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3597: )
3598: OR ( assignment_type = 'B'
3599: AND NOT EXISTS (
3600: SELECT assignment_id
3601: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3602: WHERE asg2.assignment_type = 'E'
3603: AND asg2.primary_flag = 'Y'
3604: AND asg2.person_id = pil.person_id
3605: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 3723: FROM per_all_assignments_f asg, per_assignment_status_types ast

3719: or
3720: /* check if the person belongs to the org or location specified */
3721: /* Bug 5435002 */
3722: exists (select 's'
3723: FROM per_all_assignments_f asg, per_assignment_status_types ast
3724: WHERE asg.person_id = ppf.person_id
3725: AND asg.primary_flag = 'Y'
3726: and (g_parm.organization_id is null or
3727: asg.organization_id = g_parm.organization_id)

Line 3739: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3735: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3736: OR ( ast.per_system_status = 'TERM_ASSIGN'
3737: AND NOT EXISTS (
3738: SELECT assignment_id
3739: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3740: WHERE asg1.assignment_type = 'B'
3741: AND asg1.primary_flag = 'Y'
3742: AND asg1.person_id = ppf.person_id
3743: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3754: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3750: )
3751: OR ( assignment_type = 'B'
3752: AND NOT EXISTS (
3753: SELECT assignment_id
3754: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3755: WHERE asg2.assignment_type = 'E'
3756: AND asg2.primary_flag = 'Y'
3757: AND asg2.person_id = ppf.person_id
3758: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 3858: FROM per_all_assignments_f asg, per_assignment_status_types ast

3854: or
3855: /* check if the person belongs to the org or location specified */
3856: /* Bug 5435002 */
3857: exists (select 's'
3858: FROM per_all_assignments_f asg, per_assignment_status_types ast
3859: WHERE asg.person_id = ppf.person_id
3860: AND asg.primary_flag = 'Y'
3861: and (g_parm.organization_id is null or
3862: asg.organization_id = g_parm.organization_id)

Line 3874: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3870: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3871: OR ( ast.per_system_status = 'TERM_ASSIGN'
3872: AND NOT EXISTS (
3873: SELECT assignment_id
3874: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3875: WHERE asg1.assignment_type = 'B'
3876: AND asg1.primary_flag = 'Y'
3877: AND asg1.person_id = ppf.person_id
3878: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3889: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3885: )
3886: OR ( assignment_type = 'B'
3887: AND NOT EXISTS (
3888: SELECT assignment_id
3889: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3890: WHERE asg2.assignment_type = 'E'
3891: AND asg2.primary_flag = 'Y'
3892: AND asg2.person_id = ppf.person_id
3893: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4197: FROM per_all_assignments_f asg, per_assignment_status_types ast

4193: and ((g_parm.organization_id is null and
4194: g_parm.location_id is null)
4195: or
4196: exists (select 's'
4197: FROM per_all_assignments_f asg, per_assignment_status_types ast
4198: WHERE asg.person_id = ppf.person_id
4199: AND asg.primary_flag = 'Y'
4200: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4201: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4210: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4206: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4207: OR ( ast.per_system_status = 'TERM_ASSIGN'
4208: AND NOT EXISTS (
4209: SELECT assignment_id
4210: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4211: WHERE asg1.assignment_type = 'B'
4212: AND asg1.primary_flag = 'Y'
4213: AND asg1.person_id = ppf.person_id
4214: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4225: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4221: )
4222: OR ( assignment_type = 'B'
4223: AND NOT EXISTS (
4224: SELECT assignment_id
4225: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4226: WHERE asg2.assignment_type = 'E'
4227: AND asg2.primary_flag = 'Y'
4228: AND asg2.person_id = ppf.person_id
4229: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4280: FROM per_all_assignments_f asg, per_assignment_status_types ast

4276: and ((g_parm.organization_id is null and
4277: g_parm.location_id is null)
4278: or
4279: exists (select 's'
4280: FROM per_all_assignments_f asg, per_assignment_status_types ast
4281: WHERE asg.person_id = ppf.person_id
4282: AND asg.primary_flag = 'Y'
4283: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4284: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4293: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4289: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4290: OR ( ast.per_system_status = 'TERM_ASSIGN'
4291: AND NOT EXISTS (
4292: SELECT assignment_id
4293: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4294: WHERE asg1.assignment_type = 'B'
4295: AND asg1.primary_flag = 'Y'
4296: AND asg1.person_id = ppf.person_id
4297: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4308: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4304: )
4305: OR ( assignment_type = 'B'
4306: AND NOT EXISTS (
4307: SELECT assignment_id
4308: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4309: WHERE asg2.assignment_type = 'E'
4310: AND asg2.primary_flag = 'Y'
4311: AND asg2.person_id = ppf.person_id
4312: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4357: FROM per_all_assignments_f asg, per_assignment_status_types ast

4353: and ((g_parm.organization_id is null and
4354: g_parm.location_id is null)
4355: or
4356: exists (select 's'
4357: FROM per_all_assignments_f asg, per_assignment_status_types ast
4358: WHERE asg.person_id = ppf.person_id
4359: AND asg.primary_flag = 'Y'
4360: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4361: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4370: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4366: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4367: OR ( ast.per_system_status = 'TERM_ASSIGN'
4368: AND NOT EXISTS (
4369: SELECT assignment_id
4370: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4371: WHERE asg1.assignment_type = 'B'
4372: AND asg1.primary_flag = 'Y'
4373: AND asg1.person_id = ppf.person_id
4374: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4383: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4379: ))
4380: OR ( assignment_type = 'B'
4381: AND NOT EXISTS (
4382: SELECT assignment_id
4383: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4384: WHERE asg2.assignment_type = 'E'
4385: AND asg2.primary_flag = 'Y'
4386: AND asg2.person_id = ppf.person_id
4387: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4427: FROM per_all_assignments_f asg, per_assignment_status_types ast

4423: and ((g_parm.organization_id is null and
4424: g_parm.location_id is null)
4425: or
4426: exists (select 's'
4427: FROM per_all_assignments_f asg, per_assignment_status_types ast
4428: WHERE asg.person_id = ppf.person_id
4429: AND asg.primary_flag = 'Y'
4430: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4431: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4440: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4436: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4437: OR ( ast.per_system_status = 'TERM_ASSIGN'
4438: AND NOT EXISTS (
4439: SELECT assignment_id
4440: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4441: WHERE asg1.assignment_type = 'B'
4442: AND asg1.primary_flag = 'Y'
4443: AND asg1.person_id = ppf.person_id
4444: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4453: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4449: ))
4450: OR ( assignment_type = 'B'
4451: AND NOT EXISTS (
4452: SELECT assignment_id
4453: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4454: WHERE asg2.assignment_type = 'E'
4455: AND asg2.primary_flag = 'Y'
4456: AND asg2.person_id = ppf.person_id
4457: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4484: FROM per_all_assignments_f asg, per_assignment_status_types ast

4480: and ((g_parm.organization_id is null and
4481: g_parm.location_id is null)
4482: or
4483: exists (select 's'
4484: FROM per_all_assignments_f asg, per_assignment_status_types ast
4485: WHERE asg.person_id = ppf.person_id
4486: AND asg.primary_flag = 'Y'
4487: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4488: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4497: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4493: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4494: OR ( ast.per_system_status = 'TERM_ASSIGN'
4495: AND NOT EXISTS (
4496: SELECT assignment_id
4497: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4498: WHERE asg1.assignment_type = 'B'
4499: AND asg1.primary_flag = 'Y'
4500: AND asg1.person_id = ppf.person_id
4501: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4510: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4506: ))
4507: OR ( assignment_type = 'B'
4508: AND NOT EXISTS (
4509: SELECT assignment_id
4510: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4511: WHERE asg2.assignment_type = 'E'
4512: AND asg2.primary_flag = 'Y'
4513: AND asg2.person_id = ppf.person_id
4514: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id