APPS.CN_COLLECTION_AIA_PUB dependencies on CN_SALESREPS

Line 55: FROM cn_salesreps

51:
52: CURSOR get_res_num_from_src_num(p_employee_number varchar2)
53: IS
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

Line 65: FROM cn_salesreps

61:
62: CURSOR get_salesrep_from_res_num(p_employee_number varchar2)
63: IS
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

Line 74: SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;

70: );
71:
72: CURSOR get_res_num_from_salesrep(p_salesrep_id number)
73: IS
74: SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;
75:
76: CURSOR get_src_num_from_salesrep(p_salesrep_id number)
77: IS
78: SELECT source_number

Line 81: ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id

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:
84: CURSOR check_order_number(p_order_number varchar2)
85: IS

Line 975: FROM cn_salesreps

971:
972: CURSOR get_res_num_from_src_num(p_employee_number varchar2)
973: IS
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

Line 985: FROM cn_salesreps

981:
982: CURSOR get_salesrep_from_res_num(p_employee_number varchar2)
983: IS
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

Line 994: SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;

990: );
991:
992: CURSOR get_res_num_from_salesrep(p_salesrep_id number)
993: IS
994: SELECT employee_number FROM cn_salesreps WHERE salesrep_id = p_salesrep_id;
995:
996: CURSOR get_src_num_from_salesrep(p_salesrep_id number)
997: IS
998: SELECT source_number

Line 1001: ( SELECT resource_id FROM cn_salesreps WHERE salesrep_id = p_salesrep_id

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:
1004: CURSOR check_invoice_number(p_invoice_number varchar2)
1005: IS