APPS.CN_COLLECTION_AIA_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 58: FROM jtf_rs_resource_extns

54: SELECT employee_number
55: FROM cn_salesreps
56: WHERE resource_id IN
57: (SELECT resource_id
58: FROM jtf_rs_resource_extns
59: WHERE source_number = p_employee_number
60: );
61:
62: CURSOR get_salesrep_from_res_num(p_employee_number varchar2)

Line 68: FROM jtf_rs_resource_extns

64: SELECT salesrep_id
65: FROM cn_salesreps
66: WHERE resource_id IN
67: (SELECT resource_id
68: FROM jtf_rs_resource_extns
69: WHERE source_number = p_employee_number
70: );
71:
72: CURSOR get_res_num_from_salesrep(p_salesrep_id number)

Line 79: FROM jtf_rs_resource_extns

75:
76: CURSOR get_src_num_from_salesrep(p_salesrep_id number)
77: IS
78: SELECT source_number
79: FROM jtf_rs_resource_extns
80: WHERE resource_id IN
81: ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id
82: ) ;
83:

Line 978: FROM jtf_rs_resource_extns

974: SELECT employee_number
975: FROM cn_salesreps
976: WHERE resource_id IN
977: (SELECT resource_id
978: FROM jtf_rs_resource_extns
979: WHERE source_number = p_employee_number
980: );
981:
982: CURSOR get_salesrep_from_res_num(p_employee_number varchar2)

Line 988: FROM jtf_rs_resource_extns

984: SELECT salesrep_id
985: FROM cn_salesreps
986: WHERE resource_id IN
987: (SELECT resource_id
988: FROM jtf_rs_resource_extns
989: WHERE source_number = p_employee_number
990: );
991:
992: CURSOR get_res_num_from_salesrep(p_salesrep_id number)

Line 999: FROM jtf_rs_resource_extns

995:
996: CURSOR get_src_num_from_salesrep(p_salesrep_id number)
997: IS
998: SELECT source_number
999: FROM jtf_rs_resource_extns
1000: WHERE resource_id IN
1001: ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id
1002: ) ;
1003: