APPS.POS_VENDOR_REG_PKG dependencies on POS_CONTACT_REQUESTS

Line 564: FROM pos_contact_requests pcr

560: */
561: CURSOR l_cur IS
562: SELECT pcr.contact_request_id, pcr.email_address,
563: psm.vendor_id, create_user_account
564: FROM pos_contact_requests pcr
565: , pos_supplier_mappings psm
566: WHERE (pcr.request_type = 'ADD'
567: OR pcr.request_type = 'ADD_PARTY_CONTACT')
568: AND pcr.request_status = 'PENDING'

Line 746: FROM pos_contact_requests pcr, fnd_user fu

742: )
743: IS
744: CURSOR l_cur IS
745: SELECT fu.user_name, fu.user_id
746: FROM pos_contact_requests pcr, fnd_user fu
747: WHERE pcr.mapping_id =
748: (SELECT mapping_id
749: FROM pos_supplier_mappings
750: WHERE supplier_reg_id = p_supplier_reg_id

Line 1448: UPDATE pos_contact_requests

1444: (SELECT mapping_id FROM pos_supplier_mappings
1445: WHERE supplier_reg_id = p_supplier_reg_id)
1446: AND request_status = 'PENDING';
1447:
1448: UPDATE pos_contact_requests
1449: SET request_status = 'REJECTED',
1450: last_update_date = Sysdate,
1451: last_updated_by = fnd_global.user_id,
1452: last_update_login = fnd_global.login_id