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 3512: FROM per_all_assignments_f asg, per_assignment_status_types ast

3508: or
3509: /* check if the person belongs to the org or location specified */
3510: /* Bug 5435002 */
3511: exists (select 's'
3512: FROM per_all_assignments_f asg, per_assignment_status_types ast
3513: WHERE asg.person_id = pil.person_id
3514: AND asg.primary_flag = 'Y'
3515: and (g_parm.organization_id is null or
3516: asg.organization_id = g_parm.organization_id)

Line 3528: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3524: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3525: OR ( ast.per_system_status = 'TERM_ASSIGN'
3526: AND NOT EXISTS (
3527: SELECT assignment_id
3528: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3529: WHERE asg1.assignment_type = 'B'
3530: AND asg1.primary_flag = 'Y'
3531: AND asg1.person_id = pil.person_id
3532: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3543: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3539: )
3540: OR ( assignment_type = 'B'
3541: AND NOT EXISTS (
3542: SELECT assignment_id
3543: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3544: WHERE asg2.assignment_type = 'E'
3545: AND asg2.primary_flag = 'Y'
3546: AND asg2.person_id = pil.person_id
3547: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 3665: FROM per_all_assignments_f asg, per_assignment_status_types ast

3661: or
3662: /* check if the person belongs to the org or location specified */
3663: /* Bug 5435002 */
3664: exists (select 's'
3665: FROM per_all_assignments_f asg, per_assignment_status_types ast
3666: WHERE asg.person_id = ppf.person_id
3667: AND asg.primary_flag = 'Y'
3668: and (g_parm.organization_id is null or
3669: asg.organization_id = g_parm.organization_id)

Line 3681: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3677: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3678: OR ( ast.per_system_status = 'TERM_ASSIGN'
3679: AND NOT EXISTS (
3680: SELECT assignment_id
3681: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3682: WHERE asg1.assignment_type = 'B'
3683: AND asg1.primary_flag = 'Y'
3684: AND asg1.person_id = ppf.person_id
3685: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3696: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3692: )
3693: OR ( assignment_type = 'B'
3694: AND NOT EXISTS (
3695: SELECT assignment_id
3696: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3697: WHERE asg2.assignment_type = 'E'
3698: AND asg2.primary_flag = 'Y'
3699: AND asg2.person_id = ppf.person_id
3700: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 3800: FROM per_all_assignments_f asg, per_assignment_status_types ast

3796: or
3797: /* check if the person belongs to the org or location specified */
3798: /* Bug 5435002 */
3799: exists (select 's'
3800: FROM per_all_assignments_f asg, per_assignment_status_types ast
3801: WHERE asg.person_id = ppf.person_id
3802: AND asg.primary_flag = 'Y'
3803: and (g_parm.organization_id is null or
3804: asg.organization_id = g_parm.organization_id)

Line 3816: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

3812: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
3813: OR ( ast.per_system_status = 'TERM_ASSIGN'
3814: AND NOT EXISTS (
3815: SELECT assignment_id
3816: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
3817: WHERE asg1.assignment_type = 'B'
3818: AND asg1.primary_flag = 'Y'
3819: AND asg1.person_id = ppf.person_id
3820: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 3831: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

3827: )
3828: OR ( assignment_type = 'B'
3829: AND NOT EXISTS (
3830: SELECT assignment_id
3831: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
3832: WHERE asg2.assignment_type = 'E'
3833: AND asg2.primary_flag = 'Y'
3834: AND asg2.person_id = ppf.person_id
3835: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4136: FROM per_all_assignments_f asg, per_assignment_status_types ast

4132: and ((g_parm.organization_id is null and
4133: g_parm.location_id is null)
4134: or
4135: exists (select 's'
4136: FROM per_all_assignments_f asg, per_assignment_status_types ast
4137: WHERE asg.person_id = ppf.person_id
4138: AND asg.primary_flag = 'Y'
4139: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4140: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4149: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4145: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4146: OR ( ast.per_system_status = 'TERM_ASSIGN'
4147: AND NOT EXISTS (
4148: SELECT assignment_id
4149: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4150: WHERE asg1.assignment_type = 'B'
4151: AND asg1.primary_flag = 'Y'
4152: AND asg1.person_id = ppf.person_id
4153: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4164: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4160: )
4161: OR ( assignment_type = 'B'
4162: AND NOT EXISTS (
4163: SELECT assignment_id
4164: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4165: WHERE asg2.assignment_type = 'E'
4166: AND asg2.primary_flag = 'Y'
4167: AND asg2.person_id = ppf.person_id
4168: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4219: FROM per_all_assignments_f asg, per_assignment_status_types ast

4215: and ((g_parm.organization_id is null and
4216: g_parm.location_id is null)
4217: or
4218: exists (select 's'
4219: FROM per_all_assignments_f asg, per_assignment_status_types ast
4220: WHERE asg.person_id = ppf.person_id
4221: AND asg.primary_flag = 'Y'
4222: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4223: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4232: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4228: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4229: OR ( ast.per_system_status = 'TERM_ASSIGN'
4230: AND NOT EXISTS (
4231: SELECT assignment_id
4232: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4233: WHERE asg1.assignment_type = 'B'
4234: AND asg1.primary_flag = 'Y'
4235: AND asg1.person_id = ppf.person_id
4236: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4247: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4243: )
4244: OR ( assignment_type = 'B'
4245: AND NOT EXISTS (
4246: SELECT assignment_id
4247: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4248: WHERE asg2.assignment_type = 'E'
4249: AND asg2.primary_flag = 'Y'
4250: AND asg2.person_id = ppf.person_id
4251: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4292: FROM per_all_assignments_f asg, per_assignment_status_types ast

4288: and ((g_parm.organization_id is null and
4289: g_parm.location_id is null)
4290: or
4291: exists (select 's'
4292: FROM per_all_assignments_f asg, per_assignment_status_types ast
4293: WHERE asg.person_id = ppf.person_id
4294: AND asg.primary_flag = 'Y'
4295: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4296: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4305: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4301: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4302: OR ( ast.per_system_status = 'TERM_ASSIGN'
4303: AND NOT EXISTS (
4304: SELECT assignment_id
4305: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4306: WHERE asg1.assignment_type = 'B'
4307: AND asg1.primary_flag = 'Y'
4308: AND asg1.person_id = ppf.person_id
4309: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4318: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4314: ))
4315: OR ( assignment_type = 'B'
4316: AND NOT EXISTS (
4317: SELECT assignment_id
4318: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4319: WHERE asg2.assignment_type = 'E'
4320: AND asg2.primary_flag = 'Y'
4321: AND asg2.person_id = ppf.person_id
4322: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4362: FROM per_all_assignments_f asg, per_assignment_status_types ast

4358: and ((g_parm.organization_id is null and
4359: g_parm.location_id is null)
4360: or
4361: exists (select 's'
4362: FROM per_all_assignments_f asg, per_assignment_status_types ast
4363: WHERE asg.person_id = ppf.person_id
4364: AND asg.primary_flag = 'Y'
4365: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4366: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4375: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4371: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4372: OR ( ast.per_system_status = 'TERM_ASSIGN'
4373: AND NOT EXISTS (
4374: SELECT assignment_id
4375: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4376: WHERE asg1.assignment_type = 'B'
4377: AND asg1.primary_flag = 'Y'
4378: AND asg1.person_id = ppf.person_id
4379: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4388: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4384: ))
4385: OR ( assignment_type = 'B'
4386: AND NOT EXISTS (
4387: SELECT assignment_id
4388: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4389: WHERE asg2.assignment_type = 'E'
4390: AND asg2.primary_flag = 'Y'
4391: AND asg2.person_id = ppf.person_id
4392: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id

Line 4419: FROM per_all_assignments_f asg, per_assignment_status_types ast

4415: and ((g_parm.organization_id is null and
4416: g_parm.location_id is null)
4417: or
4418: exists (select 's'
4419: FROM per_all_assignments_f asg, per_assignment_status_types ast
4420: WHERE asg.person_id = ppf.person_id
4421: AND asg.primary_flag = 'Y'
4422: and (g_parm.organization_id is null or asg.organization_id = g_parm.organization_id)
4423: and (g_parm.location_id is null or asg.location_id = g_parm.location_id)

Line 4432: FROM per_all_assignments_f asg1, per_assignment_status_types ast1

4428: AND ( ast.per_system_status = 'ACTIVE_ASSIGN'
4429: OR ( ast.per_system_status = 'TERM_ASSIGN'
4430: AND NOT EXISTS (
4431: SELECT assignment_id
4432: FROM per_all_assignments_f asg1, per_assignment_status_types ast1
4433: WHERE asg1.assignment_type = 'B'
4434: AND asg1.primary_flag = 'Y'
4435: AND asg1.person_id = ppf.person_id
4436: AND asg1.assignment_status_type_id = ast1.assignment_status_type_id

Line 4445: FROM per_all_assignments_f asg2, per_assignment_status_types ast2

4441: ))
4442: OR ( assignment_type = 'B'
4443: AND NOT EXISTS (
4444: SELECT assignment_id
4445: FROM per_all_assignments_f asg2, per_assignment_status_types ast2
4446: WHERE asg2.assignment_type = 'E'
4447: AND asg2.primary_flag = 'Y'
4448: AND asg2.person_id = ppf.person_id
4449: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id