APPS.PVX_MISC_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 67: FROM JTF_RS_RESOURCE_EXTNS

63:
64: -- Cursor : c_resource_detail
65: CURSOR c_resource_detail (cv_resource_id IN NUMBER) IS
66: SELECT source_id,user_id, substr(source_name,1,20)
67: FROM JTF_RS_RESOURCE_EXTNS
68: WHERE resource_id = cv_resource_id;
69: -- Cursor related variables
70: l_source_id NUMBER;
71: l_user_id NUMBER;

Line 105: FROM JTF_RS_RESOURCE_EXTNS RES ,JTF_RS_ROLE_RELATIONS RREL ,JTF_RS_ROLES_VL ROLE

101: -- "BUG:1706709"
102: -- Cursor : c_sales_group
103: CURSOR c_sales_group (cv_salesforce_id IN NUMBER) IS
104: SELECT GRPREL.group_id
105: FROM JTF_RS_RESOURCE_EXTNS RES ,JTF_RS_ROLE_RELATIONS RREL ,JTF_RS_ROLES_VL ROLE
106: ,JTF_RS_GROUPS_TL GROUPS ,JTF_RS_GROUP_USAGES U ,JTF_RS_GROUP_MEMBERS GRPREL
107: WHERE RES.category = 'EMPLOYEE' AND ROLE.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
108: AND RREL.role_id = ROLE.role_id AND GROUPS.language = userenv('LANG') AND GRPREL.group_id = GROUPS.group_id
109: AND NVL(RREL.delete_flag,'N') = 'N' AND RREL.start_date_active <= sysdate

Line 559: FROM jtf_rs_resource_extns jrre ,jtf_rs_resource_extns_tl jrret

555:
556: CURSOR c_complete IS
557: SELECT jrre.resource_number,jrret.resource_name,jrre.source_name,jrre.source_org_id,
558: jrre.source_first_name,jrre.source_last_name,jrre.source_middle_name
559: FROM jtf_rs_resource_extns jrre ,jtf_rs_resource_extns_tl jrret
560: WHERE jrre.resource_id = p_admin_rec.role_resource_id
561: AND jrre.resource_id = jrret.resource_id ;
562:
563: l_admin_rec c_complete%ROWTYPE;

Line 1844: FROM jtf_rs_resource_extns

1840:
1841: CURSOR c_resource_status (p_resource_id IN NUMBER) IS
1842: SELECT start_date_active,
1843: end_date_active
1844: FROM jtf_rs_resource_extns
1845: WHERE resource_id = p_resource_id;
1846:
1847: CURSOR c_party_name (p_party_id IN NUMBER) IS
1848: SELECT SUBSTRB(party_name, 1, 100) partner_name,

Line 2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca

2117: and hzca.party_id = pvpp.partner_party_id);
2118:
2119: CURSOR c_get_prtnrcntct_wo_role IS
2120: select hzr.party_id, max(hzca.cust_account_id) cust_account_id
2121: from jtf_rs_resource_extns jtfre, hz_relationships hzr, hz_cust_accounts hzca
2122: where jtfre.category= 'PARTY'
2123: and jtfre.user_id is not null
2124: and jtfre.source_id = hzr.party_id
2125: and hzr.object_id in (select pvpp.partner_party_id