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.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_ROLES_VL

Line 678: jtf_rs_roles_vl ROLE,

674: FROM jtf_rs_resource_extns RES,
675: jtf_rs_group_members GRPMEM,
676: jtf_rs_group_usages GRPUSG,
677: jtf_rs_role_relations ROLRELAT ,
678: jtf_rs_roles_vl ROLE,
679: jtf_rs_groups_b b
680:
681: WHERE RES.resource_id = cv_resource_id
682: AND RES.category = 'EMPLOYEE'

Line 792: jtf_rs_roles_vl ROLE

788: jtf_rs_group_members GRPMEM,
789: jtf_rs_groups_b GROUPB,
790: jtf_rs_group_usages GRPUSG,
791: jtf_rs_role_relations ROLRELAT ,
792: jtf_rs_roles_vl ROLE
793:
794: WHERE GRPMEM.resource_id = RES.resource_id
795: AND nvl(GRPMEM.delete_flag, 'N') = 'N'
796: AND GRPMEM.group_id = GROUPB.group_id

Line 4656: jtf_rs_roles_vl ROLE

4652: jtf_rs_resource_extns RES ,
4653: jtf_rs_group_members GRPMEM,
4654: jtf_rs_group_usages GRPUSG,
4655: jtf_rs_role_relations ROLRELAT ,
4656: jtf_rs_roles_vl ROLE
4657: WHERE HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'
4658: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4659: AND HZPR_PART_CONT.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4660: AND HZPR_PART_CONT.status = 'A'