APPS.POS_VENDOR_REG_PKG dependencies on POS_ADDRESS_REQUESTS

Line 522: FROM pos_address_requests par

518: x_msg_data OUT nocopy VARCHAR2
519: ) IS
520: CURSOR l_cur IS
521: SELECT par.address_request_id
522: FROM pos_address_requests par
523: , pos_supplier_mappings psm
524: WHERE par.request_type = 'ADD'
525: AND par.request_status = 'PENDING'
526: AND par.mapping_id = psm.mapping_id

Line 892: FROM pos_address_requests par,

888: IS
889:
890: CURSOR l_cur IS
891: SELECT par.address_request_id, par.party_site_id
892: FROM pos_address_requests par,
893: pos_supplier_mappings psm
894: WHERE par.request_type = 'ADD'
895: AND par.mapping_id = psm.mapping_id
896: AND par.party_site_id IS NOT NULL

Line 1438: UPDATE pos_address_requests

1434: last_updated_by = fnd_global.user_id,
1435: last_update_login = fnd_global.login_id
1436: WHERE supplier_reg_id = p_supplier_reg_id;
1437:
1438: UPDATE pos_address_requests
1439: SET request_status = 'REJECTED',
1440: last_update_date = Sysdate,
1441: last_updated_by = fnd_global.user_id,
1442: last_update_login = fnd_global.login_id